Informe de servicios Simalga Nacional enero-septiembre 2022

Dataset statistics

Number of variables	39
Number of observations	119468
Missing cells	352641
Missing cells (%)	7.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	35.5 MiB
Average record size in memory	312.0 B

Variable types

Numeric	7
Categorical	26
DateTime	6

Alerts

`Coste MOE` has constant value " 0.00 €"	Constant
`Centro de coste` has constant value " "	Constant
`Descripción` has a high cardinality: 7192 distinct values	High cardinality
`DNI` has a high cardinality: 16700 distinct values	High cardinality
`Desc. Equipo` has a high cardinality: 12589 distinct values	High cardinality
`Generador OT` has a high cardinality: 69 distinct values	High cardinality
`Observaciones Aviso` has a high cardinality: 82 distinct values	High cardinality
`Descripción de los Trabajos Realizados` has a high cardinality: 7141 distinct values	High cardinality
`Observaciones` has a high cardinality: 1034 distinct values	High cardinality
`Centro de trabajo` has a high cardinality: 378 distinct values	High cardinality
`Árbol departamental` has a high cardinality: 1014 distinct values	High cardinality
`Coste Material` has a high cardinality: 192 distinct values	High cardinality
`Tipo de Componente` has a high cardinality: 139 distinct values	High cardinality
`Núm. Serie` has a high cardinality: 1463 distinct values	High cardinality
`Operario PDA` has a high cardinality: 76 distinct values	High cardinality
`O.T.` is highly correlated with `Núm. Aviso`	High correlation
`Núm. Aviso` is highly correlated with `O.T.` and 1 other fields	High correlation
`Prioridad` is highly correlated with `Tipo` and 5 other fields	High correlation
`tiempo_parada_horas` is highly correlated with `Coste MOE` and 1 other fields	High correlation
`Coste MOI` is highly correlated with `Coste MOE` and 1 other fields	High correlation
`Generador OT` is highly correlated with `Tipo` and 9 other fields	High correlation
`Coste MOE` is highly correlated with `Prioridad` and 14 other fields	High correlation
`Estado` is highly correlated with `Operario PDA` and 1 other fields	High correlation
`Solicitante` is highly correlated with `Generador OT` and 2 other fields	High correlation
`Servicio` is highly correlated with `Tipo` and 5 other fields	High correlation
`Operario PDA` is highly correlated with `Tipo` and 9 other fields	High correlation
`Observaciones Aviso` is highly correlated with `Núm. Aviso` and 6 other fields	High correlation
`Centro de coste` is highly correlated with `Prioridad` and 14 other fields	High correlation
`Tipo Intervención` is highly correlated with `Tipo` and 9 other fields	High correlation
`Generador Aviso` is highly correlated with `Generador OT` and 4 other fields	High correlation
`Matrícula` is highly correlated with `Generador OT` and 1 other fields	High correlation
`Tipo` is highly correlated with `Generador OT` and 5 other fields	High correlation
`Tipo de Incidencia` is highly correlated with `Tipo` and 3 other fields	High correlation
`tiempo_parada_minutos` is highly correlated with `Generador Aviso` and 2 other fields	High correlation
`tiempo_estimado_horas` is highly correlated with `Operario PDA`	High correlation
`tiempo_estimado_minutos` is highly correlated with `Tipo Intervención` and 3 other fields	High correlation
`tiempo_mo_minutos` is highly correlated with `Estado` and 1 other fields	High correlation
`Núm. Aviso` has 118578 (99.3%) missing values	Missing
`Datetime_aviso` has 118578 (99.3%) missing values	Missing
`Datetime_inicio` has 4188 (3.5%) missing values	Missing
`Datetime_fin` has 65019 (54.4%) missing values	Missing
`Datetime_realización` has 46278 (38.7%) missing values	Missing
`tiempo_parada_minutos` is highly skewed (γ1 = 106.3054263)	Skewed
`tiempo_parada_minutos` has 119453 (> 99.9%) zeros	Zeros
`tiempo_estimado_horas` has 99986 (83.7%) zeros	Zeros
`tiempo_estimado_minutos` has 38368 (32.1%) zeros	Zeros
`tiempo_mo_horas` has 105592 (88.4%) zeros	Zeros
`tiempo_mo_minutos` has 69510 (58.2%) zeros	Zeros

Reproduction

Analysis started	2022-09-08 14:08:46.144613
Analysis finished	2022-09-08 14:11:46.324453
Duration	3 minutes and 0.18 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

O.T.
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	48967
Distinct (%)	41.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	203135.5406

Minimum	68544
Maximum	230223
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	933.5 KiB

Quantile statistics

Minimum	68544
5-th percentile	179791
Q1	191729
median	204771
Q3	215939
95-th percentile	226351
Maximum	230223
Range	161679
Interquartile range (IQR)	24210

Descriptive statistics

Standard deviation	16071.47782
Coefficient of variation (CV)	0.07911701604
Kurtosis	1.874809237
Mean	203135.5406
Median Absolute Deviation (MAD)	11384
Skewness	-0.7220734322
Sum	2.426819676 × 10¹⁰
Variance	258292399.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
226249	366	0.3%
220724	332	0.3%
204744	332	0.3%
187154	332	0.3%
210310	328	0.3%
204890	326	0.3%
204818	306	0.3%
203655	300	0.3%
194388	288	0.2%
210267	282	0.2%
Other values (48957)	116276	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
68544	1	< 0.1%
69275	1	< 0.1%
90563	1	< 0.1%
95906	1	< 0.1%
101847	1	< 0.1%
103766	1	< 0.1%
104928	1	< 0.1%
105430	2	< 0.1%
105738	34	< 0.1%
105779	2	< 0.1%

Value	Count	Frequency (%)
230223	1	< 0.1%
230222	1	< 0.1%
230221	1	< 0.1%
230220	1	< 0.1%
230219	1	< 0.1%
230218	1	< 0.1%
230217	1	< 0.1%
230216	1	< 0.1%
230215	1	< 0.1%
230214	1	< 0.1%

Núm. Aviso
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	888
Distinct (%)	99.8%
Missing	118578
Missing (%)	99.3%
Infinite	0
Infinite (%)	0.0%
Mean	2929.619101

Minimum	1904
Maximum	3400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	933.5 KiB

Quantile statistics

Minimum	1904
5-th percentile	2517.45
Q1	2702.25
median	2933.5
Q3	3161.75
95-th percentile	3345.55
Maximum	3400
Range	1496
Interquartile range (IQR)	459.5

Descriptive statistics

Standard deviation	273.4977989
Coefficient of variation (CV)	0.09335609491
Kurtosis	-0.6314032097
Mean	2929.619101
Median Absolute Deviation (MAD)	230
Skewness	-0.1712028438
Sum	2607361
Variance	74801.04598
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2565	2	< 0.1%
2947	2	< 0.1%
2748	1	< 0.1%
2739	1	< 0.1%
2740	1	< 0.1%
2743	1	< 0.1%
2745	1	< 0.1%
2744	1	< 0.1%
2746	1	< 0.1%
2750	1	< 0.1%
Other values (878)	878	0.7%
(Missing)	118578	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1904	1	< 0.1%
1910	1	< 0.1%
1975	1	< 0.1%
2074	1	< 0.1%
2220	1	< 0.1%
2384	1	< 0.1%
2474	1	< 0.1%
2478	1	< 0.1%
2479	1	< 0.1%
2480	1	< 0.1%

Value	Count	Frequency (%)
3400	1	< 0.1%
3399	1	< 0.1%
3397	1	< 0.1%
3396	1	< 0.1%
3394	1	< 0.1%
3393	1	< 0.1%
3392	1	< 0.1%
3391	1	< 0.1%
3390	1	< 0.1%
3389	1	< 0.1%

Tipo
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

Preventivo	105341
Correctivo	8800
Conductivo	5327

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1194680
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Preventivo
2nd row	Preventivo
3rd row	Preventivo
4th row	Preventivo
5th row	Preventivo

Common Values

Value	Count	Frequency (%)
Preventivo	105341	88.2%
Correctivo	8800	7.4%
Conductivo	5327	4.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
preventivo	105341	88.2%
correctivo	8800	7.4%
conductivo	5327	4.5%

Most occurring characters

Value	Count	Frequency (%)
v	224809	18.8%
e	219482	18.4%
o	133595	11.2%
r	122941	10.3%
t	119468	10.0%
i	119468	10.0%
n	110668	9.3%
P	105341	8.8%
C	14127	1.2%
c	14127	1.2%
Other values (2)	10654	0.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1075212	90.0%
Uppercase Letter	119468	10.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
v	224809	20.9%
e	219482	20.4%
o	133595	12.4%
r	122941	11.4%
t	119468	11.1%
i	119468	11.1%
n	110668	10.3%
c	14127	1.3%
d	5327	0.5%
u	5327	0.5%

Uppercase Letter

Value	Count	Frequency (%)
P	105341	88.2%
C	14127	11.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1194680	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
v	224809	18.8%
e	219482	18.4%
o	133595	11.2%
r	122941	10.3%
t	119468	10.0%
i	119468	10.0%
n	110668	9.3%
P	105341	8.8%
C	14127	1.2%
c	14127	1.2%
Other values (2)	10654	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1194680	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
v	224809	18.8%
e	219482	18.4%
o	133595	11.2%
r	122941	10.3%
t	119468	10.0%
i	119468	10.0%
n	110668	9.3%
P	105341	8.8%
C	14127	1.2%
c	14127	1.2%
Other values (2)	10654	0.9%

Estado
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

Realizado	73190
Abierto	46278

Length

Max length	9
Median length	9
Mean length	8.225265343
Min length	7

Characters and Unicode

Total characters	982656
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Realizado
2nd row	Realizado
3rd row	Realizado
4th row	Realizado
5th row	Realizado

Common Values

Value	Count	Frequency (%)
Realizado	73190	61.3%
Abierto	46278	38.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
realizado	73190	61.3%
abierto	46278	38.7%

Most occurring characters

Value	Count	Frequency (%)
a	146380	14.9%
e	119468	12.2%
i	119468	12.2%
o	119468	12.2%
R	73190	7.4%
l	73190	7.4%
z	73190	7.4%
d	73190	7.4%
A	46278	4.7%
b	46278	4.7%
Other values (2)	92556	9.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	863188	87.8%
Uppercase Letter	119468	12.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	146380	17.0%
e	119468	13.8%
i	119468	13.8%
o	119468	13.8%
l	73190	8.5%
z	73190	8.5%
d	73190	8.5%
b	46278	5.4%
r	46278	5.4%
t	46278	5.4%

Uppercase Letter

Value	Count	Frequency (%)
R	73190	61.3%
A	46278	38.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	982656	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	146380	14.9%
e	119468	12.2%
i	119468	12.2%
o	119468	12.2%
R	73190	7.4%
l	73190	7.4%
z	73190	7.4%
d	73190	7.4%
A	46278	4.7%
b	46278	4.7%
Other values (2)	92556	9.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	982656	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	146380	14.9%
e	119468	12.2%
i	119468	12.2%
o	119468	12.2%
R	73190	7.4%
l	73190	7.4%
z	73190	7.4%
d	73190	7.4%
A	46278	4.7%
b	46278	4.7%
Other values (2)	92556	9.4%

Descripción
Categorical

HIGH CARDINALITY

Distinct	7192
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

Bomba - Gama Mensual	15927
Control Legionela Despositos - Gama Diaria	9530
Cuadro Eléctrico - Gama Mensual	8341
Fancoil - Gama Trimestral	8289
Fancoil - Gama Semestral	3876
Other values (7187)	73505

Length

Max length	499
Median length	484
Mean length	29.95133425
Min length	4

Characters and Unicode

Total characters	3578226
Distinct characters	118
Distinct categories	16 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6687 ?
Unique (%)	5.6%

Sample

1st row	Cuadro Eléctrico - Gama Mensual
2nd row	Cuadro Eléctrico - Gama Mensual
3rd row	Vaso Expansión - Gama Mensual
4th row	Cuadro Eléctrico - Gama Mensual
5th row	Caldera Gas - Gama Trimestral

Common Values

Value	Count	Frequency (%)
Bomba - Gama Mensual	15927	13.3%
Control Legionela Despositos - Gama Diaria	9530	8.0%
Cuadro Eléctrico - Gama Mensual	8341	7.0%
Fancoil - Gama Trimestral	8289	6.9%
Fancoil - Gama Semestral	3876	3.2%
UTA - Gama Mensual	3832	3.2%
Vaso Expansión - Gama Mensual	3580	3.0%
Unidad Interior Climatización	3431	2.9%
Extintor - Gama Trimestral	3196	2.7%
Bomba - Gama Semestral	2783	2.3%
Other values (7182)	56683	47.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	110693	18.5%
gama	100835	16.9%
mensual	53250	8.9%
bomba	20506	3.4%
trimestral	19398	3.2%
control	13274	2.2%
de	12300	2.1%
fancoil	12253	2.1%
diaria	12033	2.0%
legionela	11337	1.9%
Other values (7763)	231731	38.8%

Most occurring characters

Value	Count	Frequency (%)
a	489966	13.7%
	478089	13.4%
e	196580	5.5%
r	183672	5.1%
o	181999	5.1%
i	174585	4.9%
m	173909	4.9%
l	171117	4.8%
n	160139	4.5%
s	158843	4.4%
Other values (108)	1209327	33.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2362856	66.0%
Uppercase Letter	596196	16.7%
Space Separator	478092	13.4%
Dash Punctuation	109508	3.1%
Decimal Number	20045	0.6%
Other Punctuation	7948	0.2%
Control	1667	< 0.1%
Other Letter	661	< 0.1%
Open Punctuation	463	< 0.1%
Close Punctuation	457	< 0.1%
Other values (6)	333	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	489966	20.7%
e	196580	8.3%
r	183672	7.8%
o	181999	7.7%
i	174585	7.4%
m	173909	7.4%
l	171117	7.2%
n	160139	6.8%
s	158843	6.7%
t	113075	4.8%
Other values (26)	358971	15.2%

Uppercase Letter

Value	Count	Frequency (%)
G	110020	18.5%
M	58083	9.7%
A	56015	9.4%
C	51896	8.7%
E	46668	7.8%
T	39603	6.6%
D	35227	5.9%
S	29226	4.9%
B	23958	4.0%
L	19127	3.2%
Other values (24)	126373	21.2%

Other Punctuation

Value	Count	Frequency (%)
.	3030	38.1%
/	2676	33.7%
,	1323	16.6%
:	837	10.5%
?	28	0.4%
"	27	0.3%
&	6	0.1%
•	5	0.1%
;	5	0.1%
¿	3	< 0.1%
Other values (5)	8	0.1%

Decimal Number

Value	Count	Frequency (%)
1	3984	19.9%
3	3853	19.2%
2	3499	17.5%
0	2411	12.0%
5	1738	8.7%
4	1239	6.2%
6	1175	5.9%
8	797	4.0%
7	677	3.4%
9	672	3.4%

Math Symbol

Value	Count	Frequency (%)
>	125	52.7%
<	105	44.3%
+	6	2.5%
×	1	0.4%

Control

Value	Count	Frequency (%)
	846	50.7%
	810	48.6%
	11	0.7%

Space Separator

Value	Count	Frequency (%)
	478089	> 99.9%
	3	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	109500	> 99.9%
–	8	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	377	81.4%
[	86	18.6%

Close Punctuation

Value	Count	Frequency (%)
)	371	81.2%
]	86	18.8%

Other Letter

Value	Count	Frequency (%)
º	350	53.0%
ª	311	47.0%

Modifier Symbol

Value	Count	Frequency (%)
´	1	50.0%
`	1	50.0%

Other Symbol

Value	Count	Frequency (%)
°	86	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	5	100.0%

Final Punctuation

Value	Count	Frequency (%)
”	2	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2959713	82.7%
Common	618513	17.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	489966	16.6%
e	196580	6.6%
r	183672	6.2%
o	181999	6.1%
i	174585	5.9%
m	173909	5.9%
l	171117	5.8%
n	160139	5.4%
s	158843	5.4%
t	113075	3.8%
Other values (62)	955828	32.3%

Common

Value	Count	Frequency (%)
	478089	77.3%
-	109500	17.7%
1	3984	0.6%
3	3853	0.6%
2	3499	0.6%
.	3030	0.5%
/	2676	0.4%
0	2411	0.4%
5	1738	0.3%
,	1323	0.2%
Other values (36)	8410	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3547238	99.1%
None	30970	0.9%
Punctuation	18	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	489966	13.8%
	478089	13.5%
e	196580	5.5%
r	183672	5.2%
o	181999	5.1%
i	174585	4.9%
m	173909	4.9%
l	171117	4.8%
n	160139	4.5%
s	158843	4.5%
Other values (76)	1178339	33.2%

None

Value	Count	Frequency (%)
ó	13843	44.7%
é	8705	28.1%
í	2814	9.1%
á	2297	7.4%
ñ	658	2.1%
Ó	613	2.0%
ú	490	1.6%
Ñ	361	1.2%
º	350	1.1%
ª	311	1.0%
Other values (17)	528	1.7%

Punctuation

Value	Count	Frequency (%)
–	8	44.4%
•	5	27.8%
…	2	11.1%
”	2	11.1%
“	1	5.6%

DNI
Categorical

HIGH CARDINALITY

Distinct	16700
Distinct (%)	14.0%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

EDF-TP29-EDF-MTOGN-001	900
EDF-V34-MTOGN-001	591
EDF-MM-C33-ED-MTTOGN	546
EDF-OS11-EDF-MTOGN-001	417
EDF-IDOM-ACU00-002	396
Other values (16695)	116618

Length

Max length	48
Median length	42
Mean length	24.06287876
Min length	11

Characters and Unicode

Total characters	2874744
Distinct characters	46
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1945 ?
Unique (%)	1.6%

Sample

1st row	EDF-V34-CE000-004
2nd row	EDF-V34-CE000-006
3rd row	SAT-R03-VPPE-VEXP0-004
4th row	EDF-OS11-P05-TERZ-CE000-023
5th row	SAT-R09-SANM-SANMAS-GCA70-004

Common Values

Value	Count	Frequency (%)
EDF-TP29-EDF-MTOGN-001	900	0.8%
EDF-V34-MTOGN-001	591	0.5%
EDF-MM-C33-ED-MTTOGN	546	0.5%
EDF-OS11-EDF-MTOGN-001	417	0.3%
EDF-IDOM-ACU00-002	396	0.3%
EDF-IDOM-ACU00-001	396	0.3%
EDF-OMBU3-EDIF-GEN-MTOGN	373	0.3%
EDF-UTO-PH9.11-MTOGN-001	332	0.3%
EDF-TOR77-SUR-CUB-ACU00-002	306	0.3%
EDF-TOR77-NORTE-CUB-ACU00-001	306	0.3%
Other values (16690)	114905	96.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
edf-tp29-edf-mtogn-001	900	0.8%
edf-v34-mtogn-001	591	0.5%
edf-mm-c33-ed-mttogn	546	0.5%
edf-os11-edf-mtogn-001	417	0.3%
edf-idom-acu00-002	396	0.3%
edf-idom-acu00-001	396	0.3%
edf-ombu3-edif-gen-mtogn	373	0.3%
edf-uto-ph9.11-mtogn-001	332	0.3%
edf-tor77-sur-cub-acu00-002	306	0.3%
edf-tor77-norte-cub-acu00-001	306	0.3%
Other values (16690)	114905	96.2%

Most occurring characters

Value	Count	Frequency (%)
-	544379	18.9%
0	479032	16.7%
E	153816	5.4%
A	145527	5.1%
M	132020	4.6%
C	119764	4.2%
F	112586	3.9%
T	108862	3.8%
1	107194	3.7%
S	100883	3.5%
Other values (36)	870681	30.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1489385	51.8%
Decimal Number	835846	29.1%
Dash Punctuation	544379	18.9%
Other Punctuation	3733	0.1%
Lowercase Letter	1237	< 0.1%
Connector Punctuation	146	< 0.1%
Math Symbol	18	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	153816	10.3%
A	145527	9.8%
M	132020	8.9%
C	119764	8.0%
F	112586	7.6%
T	108862	7.3%
S	100883	6.8%
D	99739	6.7%
R	74383	5.0%
P	70649	4.7%
Other values (16)	371156	24.9%

Decimal Number

Value	Count	Frequency (%)
0	479032	57.3%
1	107194	12.8%
3	58391	7.0%
2	52369	6.3%
7	27601	3.3%
4	26517	3.2%
6	24231	2.9%
5	23343	2.8%
9	19777	2.4%
8	17391	2.1%

Lowercase Letter

Value	Count	Frequency (%)
y	867	70.1%
n	124	10.0%
i	75	6.1%
t	75	6.1%
d	49	4.0%
u	47	3.8%

Dash Punctuation

Value	Count	Frequency (%)
-	544379	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	3733	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	146	100.0%

Math Symbol

Value	Count	Frequency (%)
+	18	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1490622	51.9%
Common	1384122	48.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	153816	10.3%
A	145527	9.8%
M	132020	8.9%
C	119764	8.0%
F	112586	7.6%
T	108862	7.3%
S	100883	6.8%
D	99739	6.7%
R	74383	5.0%
P	70649	4.7%
Other values (22)	372393	25.0%

Common

Value	Count	Frequency (%)
-	544379	39.3%
0	479032	34.6%
1	107194	7.7%
3	58391	4.2%
2	52369	3.8%
7	27601	2.0%
4	26517	1.9%
6	24231	1.8%
5	23343	1.7%
9	19777	1.4%
Other values (4)	21288	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2874744	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	544379	18.9%
0	479032	16.7%
E	153816	5.4%
A	145527	5.1%
M	132020	4.6%
C	119764	4.2%
F	112586	3.9%
T	108862	3.8%
1	107194	3.7%
S	100883	3.5%
Other values (36)	870681	30.3%

Desc. Equipo
Categorical

HIGH CARDINALITY

Distinct	12589
Distinct (%)	10.5%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

MANTENIMIENTO GENERAL	7725
PARÁMETROS CRÍTICOS	1432
BOMBA	1302
Deposito ACS	898
CALDERA 1	804
Other values (12584)	107307

Length

Max length	98
Median length	78
Mean length	24.80892791
Min length	2

Characters and Unicode

Total characters	2963873
Distinct characters	96
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1369 ?
Unique (%)	1.1%

Sample

1st row	CUADRO ELÉCTRICO - S2 - EXTRACCIÓN 1
2nd row	CUADRO ELÉCTRICO - S1 - GARAJE 1
3rd row	VASO DE EXPANSIÓN - SOLAR - VE04 (400L)
4th row	CUADRO ELÉCTRICO - CE-ASC.A1
5th row	CALDERA ACS - 65 kW

Common Values

Value	Count	Frequency (%)
MANTENIMIENTO GENERAL	7725	6.5%
PARÁMETROS CRÍTICOS	1432	1.2%
BOMBA	1302	1.1%
Deposito ACS	898	0.8%
CALDERA 1	804	0.7%
CALDERA 2	715	0.6%
UNIDAD DE TRATAMIENTO DE AIRE	651	0.5%
ACUMULADOR	616	0.5%
ACUMULADOR ACS	614	0.5%
MTTO GENERAL	546	0.5%
Other values (12579)	104165	87.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	56334	11.0%
bomba	18900	3.7%
1	18183	3.5%
de	16625	3.2%
2	16279	3.2%
planta	12612	2.5%
general	9983	1.9%
acs	9520	1.9%
mantenimiento	8321	1.6%
cuadro	8246	1.6%
Other values (4546)	338374	65.9%

Most occurring characters

Value	Count	Frequency (%)
	397207	13.4%
A	290271	9.8%
O	205834	6.9%
E	190236	6.4%
R	178074	6.0%
I	157382	5.3%
N	151750	5.1%
C	142068	4.8%
T	122817	4.1%
L	107086	3.6%
Other values (86)	1021148	34.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2178089	73.5%
Space Separator	397309	13.4%
Decimal Number	163117	5.5%
Lowercase Letter	98930	3.3%
Dash Punctuation	67449	2.3%
Other Punctuation	32215	1.1%
Open Punctuation	9686	0.3%
Close Punctuation	9668	0.3%
Other Letter	7041	0.2%
Math Symbol	345	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	290271	13.3%
O	205834	9.5%
E	190236	8.7%
R	178074	8.2%
I	157382	7.2%
N	151750	7.0%
C	142068	6.5%
T	122817	5.6%
L	107086	4.9%
S	94814	4.4%
Other values (23)	537757	24.7%

Lowercase Letter

Value	Count	Frequency (%)
a	12708	12.8%
o	11196	11.3%
i	9906	10.0%
r	9116	9.2%
n	8505	8.6%
e	8478	8.6%
t	7549	7.6%
d	4339	4.4%
l	4193	4.2%
c	4058	4.1%
Other values (22)	18882	19.1%

Decimal Number

Value	Count	Frequency (%)
1	46728	28.6%
2	35686	21.9%
0	20308	12.4%
3	15860	9.7%
4	11531	7.1%
5	9829	6.0%
6	7216	4.4%
8	5790	3.5%
7	5644	3.5%
9	4525	2.8%

Other Punctuation

Value	Count	Frequency (%)
.	30043	93.3%
,	861	2.7%
/	741	2.3%
:	500	1.6%
'	46	0.1%
&	20	0.1%
"	4	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	186	53.9%
<	82	23.8%
>	61	17.7%
=	16	4.6%

Space Separator

Value	Count	Frequency (%)
	397207	> 99.9%
	102	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	67414	99.9%
–	35	0.1%

Other Letter

Value	Count	Frequency (%)
º	6129	87.0%
ª	912	13.0%

Control

Value	Count	Frequency (%)
	17	70.8%
	7	29.2%

Open Punctuation

Value	Count	Frequency (%)
(	9686	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	9668	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2284060	77.1%
Common	679813	22.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	290271	12.7%
O	205834	9.0%
E	190236	8.3%
R	178074	7.8%
I	157382	6.9%
N	151750	6.6%
C	142068	6.2%
T	122817	5.4%
L	107086	4.7%
S	94814	4.2%
Other values (57)	643728	28.2%

Common

Value	Count	Frequency (%)
	397207	58.4%
-	67414	9.9%
1	46728	6.9%
2	35686	5.2%
.	30043	4.4%
0	20308	3.0%
3	15860	2.3%
4	11531	1.7%
5	9829	1.4%
(	9686	1.4%
Other values (19)	35521	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2925773	98.7%
None	38065	1.3%
Punctuation	35	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	397207	13.6%
A	290271	9.9%
O	205834	7.0%
E	190236	6.5%
R	178074	6.1%
I	157382	5.4%
N	151750	5.2%
C	142068	4.9%
T	122817	4.2%
L	107086	3.7%
Other values (69)	983048	33.6%

None

Value	Count	Frequency (%)
Ó	14365	37.7%
º	6129	16.1%
É	5386	14.1%
Í	5101	13.4%
Á	3242	8.5%
ó	1014	2.7%
ª	912	2.4%
Ñ	910	2.4%
é	475	1.2%
í	238	0.6%
Other values (6)	293	0.8%

Punctuation

Value	Count	Frequency (%)
–	35	100.0%

Generador OT
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	69
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	104937
LINO PUMAR	5255
JUAN VAZQUEZ	1938
JAVIER IGLESIAS VELASCO	719
ARTURO MORENO PEÑA	647
Other values (64)	5972

Length

Max length	36
Median length	1
Mean length	2.693717146
Min length	1

Characters and Unicode

Total characters	321813
Distinct characters	37
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	104937	87.8%
LINO PUMAR	5255	4.4%
JUAN VAZQUEZ	1938	1.6%
JAVIER IGLESIAS VELASCO	719	0.6%
ARTURO MORENO PEÑA	647	0.5%
SANTIAGO OLMOS	586	0.5%
FRANCISCO BUENO PICAZO	530	0.4%
ROBERTO LUNA PARRADO	494	0.4%
FELIX GARCÍA	376	0.3%
JAVIER CACELLER	350	0.3%
Other values (59)	3636	3.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
lino	5255	15.0%
pumar	5255	15.0%
juan	2266	6.5%
vazquez	1938	5.5%
javier	1231	3.5%
santiago	890	2.5%
arturo	774	2.2%
iglesias	719	2.0%
velasco	719	2.0%
moreno	647	1.8%
Other values (146)	15413	43.9%

Most occurring characters

Value	Count	Frequency (%)
	125513	39.0%
A	27330	8.5%
R	17564	5.5%
O	17476	5.4%
N	15008	4.7%
E	14795	4.6%
L	13203	4.1%
I	12943	4.0%
U	12432	3.9%
M	8508	2.6%
Other values (27)	57041	17.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	196144	60.9%
Space Separator	125513	39.0%
Decimal Number	156	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	27330	13.9%
R	17564	9.0%
O	17476	8.9%
N	15008	7.7%
E	14795	7.5%
L	13203	6.7%
I	12943	6.6%
U	12432	6.3%
M	8508	4.3%
P	7487	3.8%
Other values (20)	49398	25.2%

Decimal Number

Value	Count	Frequency (%)
4	49	31.4%
9	49	31.4%
2	48	30.8%
8	7	4.5%
1	2	1.3%
3	1	0.6%

Space Separator

Value	Count	Frequency (%)
	125513	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	196144	60.9%
Common	125669	39.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	27330	13.9%
R	17564	9.0%
O	17476	8.9%
N	15008	7.7%
E	14795	7.5%
L	13203	6.7%
I	12943	6.6%
U	12432	6.3%
M	8508	4.3%
P	7487	3.8%
Other values (20)	49398	25.2%

Common

Value	Count	Frequency (%)
	125513	99.9%
4	49	< 0.1%
9	49	< 0.1%
2	48	< 0.1%
8	7	< 0.1%
1	2	< 0.1%
3	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	318512	99.0%
None	3301	1.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	125513	39.4%
A	27330	8.6%
R	17564	5.5%
O	17476	5.5%
N	15008	4.7%
E	14795	4.6%
L	13203	4.1%
I	12943	4.1%
U	12432	3.9%
M	8508	2.7%
Other values (22)	53740	16.9%

None

Value	Count	Frequency (%)
Í	1111	33.7%
Á	812	24.6%
Ñ	731	22.1%
Ó	356	10.8%
É	291	8.8%

Generador Aviso
Categorical

HIGH CORRELATION

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	118578
JAVIER IGLESIAS VELASCO	516
GREGORIO VIEJO PÉREZ	113
SAREB	56
DIEGO HERNÁNDEZ GARCÍA	51
Other values (9)	154

Length

Max length	36
Median length	1
Mean length	1.147462082
Min length	1

Characters and Unicode

Total characters	137085
Distinct characters	34
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	118578	99.3%
JAVIER IGLESIAS VELASCO	516	0.4%
GREGORIO VIEJO PÉREZ	113	0.1%
SAREB	56	< 0.1%
DIEGO HERNÁNDEZ GARCÍA	51	< 0.1%
MTTO MV49	49	< 0.1%
FACILITY MANAGEMENT COLEGIO ALEMÁN 2	40	< 0.1%
JULIO EXPÓSITO	33	< 0.1%
SALVAMENTO MARITIMO - AVISOS	12	< 0.1%
JUAN VAZQUEZ	12	< 0.1%
Other values (4)	8	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
javier	516	20.2%
iglesias	516	20.2%
velasco	516	20.2%
gregorio	113	4.4%
viejo	113	4.4%
pérez	113	4.4%
sareb	56	2.2%
garcía	51	2.0%
hernández	51	2.0%
diego	51	2.0%
Other values (27)	458	17.9%

Most occurring characters

Value	Count	Frequency (%)
	120242	87.7%
E	2327	1.7%
I	2053	1.5%
A	1958	1.4%
S	1676	1.2%
V	1230	0.9%
L	1203	0.9%
O	1150	0.8%
R	1046	0.8%
G	925	0.7%
Other values (24)	3275	2.4%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	120242	87.7%
Uppercase Letter	16693	12.2%
Decimal Number	138	0.1%
Dash Punctuation	12	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	2327	13.9%
I	2053	12.3%
A	1958	11.7%
S	1676	10.0%
V	1230	7.4%
L	1203	7.2%
O	1150	6.9%
R	1046	6.3%
G	925	5.5%
J	674	4.0%
Other values (19)	2451	14.7%

Decimal Number

Value	Count	Frequency (%)
4	49	35.5%
9	49	35.5%
2	40	29.0%

Space Separator

Value	Count	Frequency (%)
	120242	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	12	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	120392	87.8%
Latin	16693	12.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	2327	13.9%
I	2053	12.3%
A	1958	11.7%
S	1676	10.0%
V	1230	7.4%
L	1203	7.2%
O	1150	6.9%
R	1046	6.3%
G	925	5.5%
J	674	4.0%
Other values (19)	2451	14.7%

Common

Value	Count	Frequency (%)
	120242	99.9%
4	49	< 0.1%
9	49	< 0.1%
2	40	< 0.1%
-	12	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	136795	99.8%
None	290	0.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	120242	87.9%
E	2327	1.7%
I	2053	1.5%
A	1958	1.4%
S	1676	1.2%
V	1230	0.9%
L	1203	0.9%
O	1150	0.8%
R	1046	0.8%
G	925	0.7%
Other values (20)	2985	2.2%

None

Value	Count	Frequency (%)
É	115	39.7%
Á	91	31.4%
Í	51	17.6%
Ó	33	11.4%

Solicitante
Categorical

HIGH CORRELATION

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	118988
RECEPCION	79
RECPCION	56
SAREB	56
Facility	40
Other values (33)	249

Length

Max length	23
Median length	1
Mean length	1.033481769
Min length	1

Characters and Unicode

Total characters	123468
Distinct characters	51
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	118988	99.6%
RECEPCION	79	0.1%
RECPCION	56	< 0.1%
SAREB	56	< 0.1%
Facility	40	< 0.1%
SGS	38	< 0.1%
LIMPIEZA	34	< 0.1%
Javier Recio A	29	< 0.1%
Pilar Hernandez G	24	< 0.1%
limpieza	12	< 0.1%
Other values (28)	112	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
recepcion	86	12.2%
sareb	56	7.9%
recpcion	56	7.9%
limpieza	50	7.1%
facility	40	5.7%
sgs	38	5.4%
g	35	5.0%
a	32	4.5%
pilar	31	4.4%
hernandez	31	4.4%
Other values (42)	250	35.5%

Most occurring characters

Value	Count	Frequency (%)
	119213	96.6%
E	336	0.3%
i	319	0.3%
C	291	0.2%
R	263	0.2%
a	231	0.2%
I	226	0.2%
P	217	0.2%
e	193	0.2%
A	183	0.1%
Other values (41)	1996	1.6%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	119213	96.6%
Uppercase Letter	2462	2.0%
Lowercase Letter	1772	1.4%
Decimal Number	14	< 0.1%
Other Punctuation	7	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	319	18.0%
a	231	13.0%
e	193	10.9%
r	168	9.5%
n	118	6.7%
c	113	6.4%
o	113	6.4%
l	106	6.0%
z	59	3.3%
t	52	2.9%
Other values (15)	300	16.9%

Uppercase Letter

Value	Count	Frequency (%)
E	336	13.6%
C	291	11.8%
R	263	10.7%
I	226	9.2%
P	217	8.8%
A	183	7.4%
S	157	6.4%
O	148	6.0%
N	141	5.7%
G	99	4.0%
Other values (12)	401	16.3%

Other Punctuation

Value	Count	Frequency (%)
.	4	57.1%
,	3	42.9%

Space Separator

Value	Count	Frequency (%)
	119213	100.0%

Decimal Number

Value	Count	Frequency (%)
4	14	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119234	96.6%
Latin	4234	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	336	7.9%
i	319	7.5%
C	291	6.9%
R	263	6.2%
a	231	5.5%
I	226	5.3%
P	217	5.1%
e	193	4.6%
A	183	4.3%
r	168	4.0%
Other values (37)	1807	42.7%

Common

Value	Count	Frequency (%)
	119213	> 99.9%
4	14	< 0.1%
.	4	< 0.1%
,	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	123464	> 99.9%
None	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	119213	96.6%
E	336	0.3%
i	319	0.3%
C	291	0.2%
R	263	0.2%
a	231	0.2%
I	226	0.2%
P	217	0.2%
e	193	0.2%
A	183	0.1%
Other values (40)	1992	1.6%

None

Value	Count	Frequency (%)
ñ	4	100.0%

Observaciones Aviso
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	82
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	119384
SERVICIO REALIZADO EL 09/08/2022	4
Welcome pack planta 1 - taquilla 2002	1
Se cambia interruptor de ventilador, se limpia y desengrasa el mismo.	1
Modificación bancada Comité Dirección planta 2 - 25.03.22	1
Other values (77)	77

Length

Max length	195
Median length	1
Mean length	1.02876084
Min length	1

Characters and Unicode

Total characters	122904
Distinct characters	80
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	80 ?
Unique (%)	0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	119384	99.9%
SERVICIO REALIZADO EL 09/08/2022	4	< 0.1%
Welcome pack planta 1 - taquilla 2002	1	< 0.1%
Se cambia interruptor de ventilador, se limpia y desengrasa el mismo.	1	< 0.1%
Modificación bancada Comité Dirección planta 2 - 25.03.22	1	< 0.1%
Sala lactancia/primeros auxilios	1	< 0.1%
Problemas diversos goteras planta 3ª	1	< 0.1%
Revisión y mantenimiento paredes interior oficina	1	< 0.1%
Distribución auditorio / sala transparencia 29.05.2021	1	< 0.1%
Revisión distribución 15 pax sala auditorio	1	< 0.1%
Other values (72)	72	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
planta	28	5.5%
y	14	2.8%
se	14	2.8%
3	13	2.6%
de	12	2.4%
sala	12	2.4%
	12	2.4%
2	8	1.6%
temperatura	6	1.2%
a	6	1.2%
Other values (286)	380	75.2%

Most occurring characters

Value	Count	Frequency (%)
	119843	97.5%
a	308	0.3%
i	190	0.2%
e	188	0.2%
o	162	0.1%
n	154	0.1%
r	139	0.1%
t	139	0.1%
l	125	0.1%
s	121	0.1%
Other values (70)	1535	1.2%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	119843	97.5%
Lowercase Letter	2074	1.7%
Uppercase Letter	712	0.6%
Decimal Number	180	0.1%
Other Punctuation	56	< 0.1%
Dash Punctuation	17	< 0.1%
Open Punctuation	7	< 0.1%
Close Punctuation	7	< 0.1%
Other Letter	5	< 0.1%
Control	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	308	14.9%
i	190	9.2%
e	188	9.1%
o	162	7.8%
n	154	7.4%
r	139	6.7%
t	139	6.7%
l	125	6.0%
s	121	5.8%
c	101	4.9%
Other values (21)	447	21.6%

Uppercase Letter

Value	Count	Frequency (%)
A	87	12.2%
E	83	11.7%
S	61	8.6%
R	60	8.4%
O	58	8.1%
I	49	6.9%
C	39	5.5%
P	38	5.3%
D	36	5.1%
L	36	5.1%
Other values (17)	165	23.2%

Decimal Number

Value	Count	Frequency (%)
2	51	28.3%
0	32	17.8%
3	32	17.8%
1	19	10.6%
5	11	6.1%
4	9	5.0%
8	8	4.4%
9	8	4.4%
6	6	3.3%
7	4	2.2%

Other Punctuation

Value	Count	Frequency (%)
.	30	53.6%
/	15	26.8%
,	9	16.1%
:	2	3.6%

Control

Value	Count	Frequency (%)
	1	50.0%
	1	50.0%

Space Separator

Value	Count	Frequency (%)
	119843	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	17	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	7	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	7	100.0%

Other Letter

Value	Count	Frequency (%)
ª	5	100.0%

Math Symbol

Value	Count	Frequency (%)
+	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	120113	97.7%
Latin	2791	2.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	308	11.0%
i	190	6.8%
e	188	6.7%
o	162	5.8%
n	154	5.5%
r	139	5.0%
t	139	5.0%
l	125	4.5%
s	121	4.3%
c	101	3.6%
Other values (49)	1164	41.7%

Common

Value	Count	Frequency (%)
	119843	99.8%
2	51	< 0.1%
0	32	< 0.1%
3	32	< 0.1%
.	30	< 0.1%
1	19	< 0.1%
-	17	< 0.1%
/	15	< 0.1%
5	11	< 0.1%
,	9	< 0.1%
Other values (11)	54	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	122859	> 99.9%
None	45	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	119843	97.5%
a	308	0.3%
i	190	0.2%
e	188	0.2%
o	162	0.1%
n	154	0.1%
r	139	0.1%
t	139	0.1%
l	125	0.1%
s	121	0.1%
Other values (63)	1490	1.2%

None

Value	Count	Frequency (%)
ó	28	62.2%
é	6	13.3%
ª	5	11.1%
á	2	4.4%
ñ	2	4.4%
Á	1	2.2%
í	1	2.2%

Fecha Prev. Realiz.
Date

Distinct	470
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

Minimum	2000-01-01 00:00:00
Maximum	2022-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Descripción de los Trabajos Realizados
Categorical

HIGH CARDINALITY

Distinct	7141
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	109440
Se realiza preventivo programado caldera centro. Sin anomalías durante la intervención.	90
analitica de agua torres	88
Se realiza preventivo programado bombas centro. Sin anomalías durante la intervención.	81
Se realiza mantenimiento conductivo diario.	80
Other values (7136)	9689

Length

Max length	502
Median length	1
Mean length	10.5466987
Min length	1

Characters and Unicode

Total characters	1259993
Distinct characters	114
Distinct categories	17 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6779 ?
Unique (%)	5.7%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	109440	91.6%
Se realiza preventivo programado caldera centro. Sin anomalías durante la intervención.	90	0.1%
analitica de agua torres	88	0.1%
Se realiza preventivo programado bombas centro. Sin anomalías durante la intervención.	81	0.1%
Se realiza mantenimiento conductivo diario.	80	0.1%
LECTURA DE CONTADORES DE AGUA DIARIA	75	0.1%
Se realiza preventivo programado enfriadora centro. Sin anomalías durante la intervención.	75	0.1%
Se realiza ronda general de clima en edificio y se ajusta la temperatura en todas las plantas	73	0.1%
chequeo de la instalacion	72	0.1%
parada	69	0.1%
Other values (7131)	9325	7.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	16934	9.2%
se	12015	6.5%
y	5954	3.2%
la	5947	3.2%
en	4725	2.6%
que	2812	1.5%
el	2785	1.5%
a	2660	1.4%
realiza	2292	1.2%
del	1781	1.0%
Other values (10367)	126180	68.5%

Most occurring characters

Value	Count	Frequency (%)
	280877	22.3%
a	101616	8.1%
e	100787	8.0%
r	59949	4.8%
o	58686	4.7%
n	57619	4.6%
i	56213	4.5%
s	45714	3.6%
t	40299	3.2%
d	38479	3.1%
Other values (104)	419754	33.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	780162	61.9%
Space Separator	280938	22.3%
Uppercase Letter	152020	12.1%
Other Punctuation	18356	1.5%
Decimal Number	17142	1.4%
Control	7840	0.6%
Dash Punctuation	2045	0.2%
Open Punctuation	377	< 0.1%
Close Punctuation	361	< 0.1%
Other Symbol	271	< 0.1%
Other values (7)	481	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	101616	13.0%
e	100787	12.9%
r	59949	7.7%
o	58686	7.5%
n	57619	7.4%
i	56213	7.2%
s	45714	5.9%
t	40299	5.2%
d	38479	4.9%
c	37687	4.8%
Other values (24)	183113	23.5%

Uppercase Letter

Value	Count	Frequency (%)
A	20506	13.5%
E	18512	12.2%
S	16235	10.7%
R	10966	7.2%
O	10811	7.1%
N	9108	6.0%
D	8716	5.7%
I	8574	5.6%
C	8392	5.5%
T	7320	4.8%
Other values (24)	32880	21.6%

Other Punctuation

Value	Count	Frequency (%)
.	11726	63.9%
,	5112	27.8%
:	688	3.7%
/	626	3.4%
"	126	0.7%
%	52	0.3%
;	8	< 0.1%
'	3	< 0.1%
@	3	< 0.1%
&	3	< 0.1%
Other values (4)	9	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	3618	21.1%
2	3430	20.0%
0	2142	12.5%
3	1756	10.2%
4	1297	7.6%
5	1265	7.4%
6	1040	6.1%
8	906	5.3%
7	869	5.1%
9	819	4.8%

Math Symbol

Value	Count	Frequency (%)
+	235	93.6%
=	11	4.4%
>	3	1.2%
<	2	0.8%

Control

Value	Count	Frequency (%)
	4709	60.1%
	3124	39.8%
	7	0.1%

Space Separator

Value	Count	Frequency (%)
	280877	> 99.9%
	61	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	2043	99.9%
–	2	0.1%

Other Letter

Value	Count	Frequency (%)
º	112	50.9%
ª	108	49.1%

Modifier Symbol

Value	Count	Frequency (%)
`	1	50.0%
´	1	50.0%

Open Punctuation

Value	Count	Frequency (%)
(	377	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	361	100.0%

Other Symbol

Value	Count	Frequency (%)
°	271	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	2	100.0%

Final Punctuation

Value	Count	Frequency (%)
”	2	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	2	100.0%

Other Number

Value	Count	Frequency (%)
³	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	932402	74.0%
Common	327591	26.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	101616	10.9%
e	100787	10.8%
r	59949	6.4%
o	58686	6.3%
n	57619	6.2%
i	56213	6.0%
s	45714	4.9%
t	40299	4.3%
d	38479	4.1%
c	37687	4.0%
Other values (60)	335353	36.0%

Common

Value	Count	Frequency (%)
	280877	85.7%
.	11726	3.6%
,	5112	1.6%
	4709	1.4%
1	3618	1.1%
2	3430	1.0%
	3124	1.0%
0	2142	0.7%
-	2043	0.6%
3	1756	0.5%
Other values (34)	9054	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1242885	98.6%
None	17099	1.4%
Punctuation	9	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	280877	22.6%
a	101616	8.2%
e	100787	8.1%
r	59949	4.8%
o	58686	4.7%
n	57619	4.6%
i	56213	4.5%
s	45714	3.7%
t	40299	3.2%
d	38479	3.1%
Other values (76)	402646	32.4%

None

Value	Count	Frequency (%)
ó	8325	48.7%
í	2972	17.4%
á	2335	13.7%
é	1026	6.0%
ú	618	3.6%
ñ	430	2.5%
Ñ	303	1.8%
°	271	1.6%
Ó	267	1.6%
º	112	0.7%
Other values (14)	440	2.6%

Punctuation

Value	Count	Frequency (%)
•	3	33.3%
“	2	22.2%
”	2	22.2%
–	2	22.2%

Observaciones
Categorical

HIGH CARDINALITY

Distinct	1034
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	118262
material en almacén	36
MATERIAL EN ALMACÉN	27
[Error en check list]	26
Inspección y toma de datos de instalación eléctrica, los resultados se detallaran en informe emitido por departamento eléctrico.	22
Other values (1029)	1095

Length

Max length	501
Median length	1
Mean length	1.472503097
Min length	1

Characters and Unicode

Total characters	175917
Distinct characters	101
Distinct categories	13 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	993 ?
Unique (%)	0.8%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	118262	99.0%
material en almacén	36	< 0.1%
MATERIAL EN ALMACÉN	27	< 0.1%
[Error en check list]	26	< 0.1%
Inspección y toma de datos de instalación eléctrica, los resultados se detallaran en informe emitido por departamento eléctrico.	22	< 0.1%
DOBLE PERSONAL	8	< 0.1%
trabajo realizado por Alberto	7	< 0.1%
P52987	5	< 0.1%
Material en almacén	5	< 0.1%
SERVICIO REALIZADO EL 09/08/2022	4	< 0.1%
Other values (1024)	1066	0.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	589	6.4%
en	310	3.3%
se	259	2.8%
y	207	2.2%
la	143	1.5%
a	116	1.3%
	116	1.3%
por	116	1.3%
el	111	1.2%
almacén	100	1.1%
Other values (2885)	7204	77.7%

Most occurring characters

Value	Count	Frequency (%)
	126342	71.8%
a	4205	2.4%
e	3994	2.3%
o	2594	1.5%
r	2467	1.4%
i	2304	1.3%
n	2124	1.2%
l	1901	1.1%
s	1841	1.0%
t	1662	0.9%
Other values (91)	26483	15.1%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	126342	71.8%
Lowercase Letter	31979	18.2%
Uppercase Letter	9694	5.5%
Decimal Number	5636	3.2%
Other Punctuation	1290	0.7%
Control	489	0.3%
Dash Punctuation	248	0.1%
Close Punctuation	74	< 0.1%
Open Punctuation	73	< 0.1%
Math Symbol	44	< 0.1%
Other values (3)	48	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	4205	13.1%
e	3994	12.5%
o	2594	8.1%
r	2467	7.7%
i	2304	7.2%
n	2124	6.6%
l	1901	5.9%
s	1841	5.8%
t	1662	5.2%
d	1637	5.1%
Other values (24)	7250	22.7%

Uppercase Letter

Value	Count	Frequency (%)
A	1306	13.5%
E	995	10.3%
S	682	7.0%
R	672	6.9%
O	670	6.9%
N	629	6.5%
I	600	6.2%
L	594	6.1%
C	488	5.0%
T	477	4.9%
Other values (23)	2581	26.6%

Decimal Number

Value	Count	Frequency (%)
0	815	14.5%
2	751	13.3%
1	728	12.9%
6	663	11.8%
5	599	10.6%
3	486	8.6%
4	460	8.2%
7	414	7.3%
9	399	7.1%
8	321	5.7%

Other Punctuation

Value	Count	Frequency (%)
.	569	44.1%
:	253	19.6%
/	226	17.5%
,	180	14.0%
!	37	2.9%
?	9	0.7%
"	8	0.6%
@	8	0.6%

Control

Value	Count	Frequency (%)
	281	57.5%
	205	41.9%
	3	0.6%

Dash Punctuation

Value	Count	Frequency (%)
-	208	83.9%
–	40	16.1%

Close Punctuation

Value	Count	Frequency (%)
)	41	55.4%
]	33	44.6%

Open Punctuation

Value	Count	Frequency (%)
(	40	54.8%
[	33	45.2%

Math Symbol

Value	Count	Frequency (%)
=	34	77.3%
+	10	22.7%

Other Letter

Value	Count	Frequency (%)
º	27	61.4%
ª	17	38.6%

Space Separator

Value	Count	Frequency (%)
	126342	100.0%

Currency Symbol

Value	Count	Frequency (%)
€	3	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	134200	76.3%
Latin	41717	23.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	4205	10.1%
e	3994	9.6%
o	2594	6.2%
r	2467	5.9%
i	2304	5.5%
n	2124	5.1%
l	1901	4.6%
s	1841	4.4%
t	1662	4.0%
d	1637	3.9%
Other values (59)	16988	40.7%

Common

Value	Count	Frequency (%)
	126342	94.1%
0	815	0.6%
2	751	0.6%
1	728	0.5%
6	663	0.5%
5	599	0.4%
.	569	0.4%
3	486	0.4%
4	460	0.3%
7	414	0.3%
Other values (22)	2373	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	175160	99.6%
None	714	0.4%
Punctuation	40	< 0.1%
Currency Symbols	3	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	126342	72.1%
a	4205	2.4%
e	3994	2.3%
o	2594	1.5%
r	2467	1.4%
i	2304	1.3%
n	2124	1.2%
l	1901	1.1%
s	1841	1.1%
t	1662	0.9%
Other values (72)	25726	14.7%

None

Value	Count	Frequency (%)
ó	249	34.9%
é	149	20.9%
í	64	9.0%
á	57	8.0%
ú	45	6.3%
É	37	5.2%
º	27	3.8%
ñ	18	2.5%
Ó	17	2.4%
ª	17	2.4%
Other values (7)	34	4.8%

Punctuation

Value	Count	Frequency (%)
–	40	100.0%

Currency Symbols

Value	Count	Frequency (%)
€	3	100.0%

Centro de trabajo
Categorical

HIGH CARDINALITY

Distinct	378
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

COLEGIO ALEMÁN DE MADRID - SAT 1 - COLEGIO ALEMÁN DE MADRID	6323
MANC. CP R. GOMEZ DE LA SERNA, 47 - SAT 1 - RAMON GOMEZ DE LA SERNA 47	5628
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - MUTUA - CASTELLANA 33	5236
AG MADRID BARAJAS SL - SAT 2 - TRESPADERNE 29 (CUSHMAN & WAKEFIELD)	3686
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - ALFREDO MAHOU	3663
Other values (373)	94932

Length

Max length	100
Median length	81
Mean length	60.3851659
Min length	25

Characters and Unicode

Total characters	7214095
Distinct characters	57
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	< 0.1%

Sample

1st row	REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34
2nd row	REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34
3rd row	VP HOTELES - SAT 2 - VP PLAZA DE ESPAÑA DESIGN
4th row	TORRE RIOJA MADRID S.A. - SAT 1 - OSIRIS 11
5th row	SANITAS MAYORES, S.L. - SAT 2 - SANITAS ARTURO SORIA

Common Values

Value	Count	Frequency (%)
COLEGIO ALEMÁN DE MADRID - SAT 1 - COLEGIO ALEMÁN DE MADRID	6323	5.3%
MANC. CP R. GOMEZ DE LA SERNA, 47 - SAT 1 - RAMON GOMEZ DE LA SERNA 47	5628	4.7%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - MUTUA - CASTELLANA 33	5236	4.4%
AG MADRID BARAJAS SL - SAT 2 - TRESPADERNE 29 (CUSHMAN & WAKEFIELD)	3686	3.1%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - ALFREDO MAHOU	3663	3.1%
ATAM PARA EL APOYO FAMILIAR - SAT 1 - ATAM - POZUELO	3491	2.9%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - CASTELLANA 36-38	3378	2.8%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - AV EUROPA 22	3293	2.8%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - CASTELLANA 50	3188	2.7%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - EDIFICIO PIRAMIDE (CASTELLANA 31)	2982	2.5%
Other values (368)	78600	65.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	261956	17.9%
sat	117377	8.0%
1	75151	5.1%
de	66888	4.6%
2	40226	2.8%
mutua	38809	2.7%
a	30374	2.1%
seguros	29927	2.0%
sociedad	29902	2.0%
prima	29854	2.0%
Other values (879)	740665	50.7%

Most occurring characters

Value	Count	Frequency (%)
	1341742	18.6%
A	851982	11.8%
S	449750	6.2%
E	446817	6.2%
I	385580	5.3%
R	317926	4.4%
O	314616	4.4%
L	297771	4.1%
T	296293	4.1%
-	264596	3.7%
Other values (47)	2247022	31.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	5092790	70.6%
Space Separator	1341742	18.6%
Decimal Number	281496	3.9%
Dash Punctuation	264596	3.7%
Other Punctuation	210087	2.9%
Open Punctuation	10781	0.1%
Close Punctuation	10781	0.1%
Lowercase Letter	1127	< 0.1%
Other Letter	695	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	851982	16.7%
S	449750	8.8%
E	446817	8.8%
I	385580	7.6%
R	317926	6.2%
O	314616	6.2%
L	297771	5.8%
T	296293	5.8%
D	258848	5.1%
M	245253	4.8%
Other values (23)	1227954	24.1%

Decimal Number

Value	Count	Frequency (%)
1	104018	37.0%
2	57043	20.3%
3	31876	11.3%
4	20964	7.4%
7	19816	7.0%
6	13290	4.7%
8	9787	3.5%
5	9079	3.2%
0	8580	3.0%
9	7043	2.5%

Lowercase Letter

Value	Count	Frequency (%)
y	403	35.8%
c	181	16.1%
e	181	16.1%
i	181	16.1%
l	181	16.1%

Other Punctuation

Value	Count	Frequency (%)
.	114837	54.7%
,	90088	42.9%
&	5081	2.4%
/	81	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1341742	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	264596	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	10781	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	10781	100.0%

Other Letter

Value	Count	Frequency (%)
º	695	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5094612	70.6%
Common	2119483	29.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	851982	16.7%
S	449750	8.8%
E	446817	8.8%
I	385580	7.6%
R	317926	6.2%
O	314616	6.2%
L	297771	5.8%
T	296293	5.8%
D	258848	5.1%
M	245253	4.8%
Other values (29)	1229776	24.1%

Common

Value	Count	Frequency (%)
	1341742	63.3%
-	264596	12.5%
.	114837	5.4%
1	104018	4.9%
,	90088	4.3%
2	57043	2.7%
3	31876	1.5%
4	20964	1.0%
7	19816	0.9%
6	13290	0.6%
Other values (8)	61213	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7150431	99.1%
None	63664	0.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1341742	18.8%
A	851982	11.9%
S	449750	6.3%
E	446817	6.2%
I	385580	5.4%
R	317926	4.4%
O	314616	4.4%
L	297771	4.2%
T	296293	4.1%
-	264596	3.7%
Other values (39)	2183358	30.5%

None

Value	Count	Frequency (%)
Ñ	38645	60.7%
Á	15323	24.1%
Ó	5938	9.3%
Í	2612	4.1%
º	695	1.1%
É	288	0.5%
Ú	147	0.2%
Ü	16	< 0.1%

Árbol departamental
Categorical

HIGH CARDINALITY

Distinct	1014
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

EDIFICIO - IDOM CONSULTING	2474
EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 33 - EDIFICIO	1931
EDIFICIO - CANOE	1925
EDIFICIO - COLEGIO ALEMÁN - Colegio - PUERTAS - INTERIORES	1752
EDIFICIO - VELAZQUEZ 34	1533
Other values (1009)	109853

Length

Max length	113
Median length	95
Mean length	54.72662973
Min length	16

Characters and Unicode

Total characters	6538081
Distinct characters	75
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17 ?
Unique (%)	< 0.1%

Sample

1st row	EDIFICIO - VELAZQUEZ 34
2nd row	EDIFICIO - VELAZQUEZ 34
3rd row	SAT - RUTA 03 - VP PLAZA DE ESPAÑA DESIGN
4th row	EDIFICIO - OSIRIS 11 (ROCHE) - PLANTA QUINTA - TERRAZA
5th row	SAT - RUTA 09 - SANITAS MAYORES, S.L. - SANITAS ARTURO SORIA

Common Values

Value	Count	Frequency (%)
EDIFICIO - IDOM CONSULTING	2474	2.1%
EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 33 - EDIFICIO	1931	1.6%
EDIFICIO - CANOE	1925	1.6%
EDIFICIO - COLEGIO ALEMÁN - Colegio - PUERTAS - INTERIORES	1752	1.5%
EDIFICIO - VELAZQUEZ 34	1533	1.3%
EDIFICIO - OSIRIS 11 (ROCHE) - AZOTEA - PLANTA INSTALACIONES	1245	1.0%
EDIFICIO - TRESPADERME 29 - EDIFICIO	1242	1.0%
EDIFICIO - TRESPADERME 29 - PCI	1187	1.0%
EDIFICIO - ATAM - POZUELO - EDIFICIO C1	1018	0.9%
EDIFICIO - ATAM - POZUELO - EDIFICIO A	952	0.8%
Other values (1004)	104209	87.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	308609	24.1%
edificio	89289	7.0%
de	47596	3.7%
sat	44289	3.5%
ruta	42871	3.3%
a	31537	2.5%
seguros	29719	2.3%
fija	29719	2.3%
prima	29719	2.3%
sociedad	29719	2.3%
Other values (887)	599494	46.7%

Most occurring characters

Value	Count	Frequency (%)
	1163183	17.8%
A	690564	10.6%
I	517887	7.9%
E	428906	6.6%
O	320974	4.9%
-	316712	4.8%
S	289188	4.4%
R	278519	4.3%
D	273069	4.2%
T	257178	3.9%
Other values (65)	2001901	30.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4626438	70.8%
Space Separator	1163183	17.8%
Dash Punctuation	316712	4.8%
Decimal Number	265588	4.1%
Lowercase Letter	74266	1.1%
Other Punctuation	56464	0.9%
Open Punctuation	17374	0.3%
Close Punctuation	17374	0.3%
Other Letter	682	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	690564	14.9%
I	517887	11.2%
E	428906	9.3%
O	320974	6.9%
S	289188	6.3%
R	278519	6.0%
D	273069	5.9%
T	257178	5.6%
C	246136	5.3%
L	221705	4.8%
Other values (22)	1102312	23.8%

Lowercase Letter

Value	Count	Frequency (%)
o	12082	16.3%
a	10528	14.2%
i	8300	11.2%
e	7280	9.8%
r	5710	7.7%
t	5268	7.1%
n	4963	6.7%
l	4943	6.7%
d	3387	4.6%
u	2804	3.8%
Other values (15)	9001	12.1%

Decimal Number

Value	Count	Frequency (%)
0	57192	21.5%
1	52049	19.6%
3	47802	18.0%
2	24236	9.1%
5	14870	5.6%
6	14545	5.5%
7	14320	5.4%
4	14250	5.4%
9	13845	5.2%
8	12479	4.7%

Other Punctuation

Value	Count	Frequency (%)
,	40911	72.5%
.	14413	25.5%
&	1140	2.0%

Space Separator

Value	Count	Frequency (%)
	1163183	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	316712	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	17374	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	17374	100.0%

Other Letter

Value	Count	Frequency (%)
º	682	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4701386	71.9%
Common	1836695	28.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	690564	14.7%
I	517887	11.0%
E	428906	9.1%
O	320974	6.8%
S	289188	6.2%
R	278519	5.9%
D	273069	5.8%
T	257178	5.5%
C	246136	5.2%
L	221705	4.7%
Other values (48)	1177260	25.0%

Common

Value	Count	Frequency (%)
	1163183	63.3%
-	316712	17.2%
0	57192	3.1%
1	52049	2.8%
3	47802	2.6%
,	40911	2.2%
2	24236	1.3%
(	17374	0.9%
)	17374	0.9%
5	14870	0.8%
Other values (7)	84992	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6481954	99.1%
None	56127	0.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1163183	17.9%
A	690564	10.7%
I	517887	8.0%
E	428906	6.6%
O	320974	5.0%
-	316712	4.9%
S	289188	4.5%
R	278519	4.3%
D	273069	4.2%
T	257178	4.0%
Other values (56)	1945774	30.0%

None

Value	Count	Frequency (%)
Ñ	32942	58.7%
Á	11332	20.2%
Ó	5814	10.4%
Í	3225	5.7%
É	1069	1.9%
º	682	1.2%
í	677	1.2%
ó	352	0.6%
Ú	34	0.1%

Tipo Intervención
Categorical

HIGH CORRELATION

Distinct	43
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

Preventivo - Climatización	25431
Preventivo - AFS	24143
Preventivo	14183
Preventivo - Legionella	10968
Preventivo - Electricidad - BT	7302
Other values (38)	37441

Length

Max length	30
Median length	28
Mean length	18.74938059
Min length	1

Characters and Unicode

Total characters	2239951
Distinct characters	42
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Preventivo - Electricidad - BT
2nd row	Preventivo - Electricidad - BT
3rd row	Preventivo - AFS
4th row	Preventivo - Electricidad - BT
5th row	Preventivo - Calefacción y ACS

Common Values

Value	Count	Frequency (%)
Preventivo - Climatización	25431	21.3%
Preventivo - AFS	24143	20.2%
Preventivo	14183	11.9%
Preventivo - Legionella	10968	9.2%
Preventivo - Electricidad - BT	7302	6.1%
Preventivo - PCI	5344	4.5%
Preventivo - Calefacción y ACS	5223	4.4%
Preventivo - Frío	5180	4.3%
Preventivo - ACS	4936	4.1%
Conductivo	4504	3.8%
Other values (33)	12254	10.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
preventivo	105319	32.1%
	99762	30.4%
climatización	25440	7.8%
afs	24143	7.4%
legionella	10968	3.3%
acs	10159	3.1%
electricidad	7549	2.3%
bt	7302	2.2%
pci	5344	1.6%
calefacción	5224	1.6%
Other values (33)	26731	8.2%

Most occurring characters

Value	Count	Frequency (%)
e	250955	11.2%
i	228514	10.2%
v	217825	9.7%
	214675	9.6%
n	153667	6.9%
t	148250	6.6%
o	137621	6.1%
r	124363	5.6%
P	111449	5.0%
-	99762	4.5%
Other values (32)	552870	24.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1613726	72.0%
Uppercase Letter	311788	13.9%
Space Separator	214675	9.6%
Dash Punctuation	99762	4.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	250955	15.6%
i	228514	14.2%
v	217825	13.5%
n	153667	9.5%
t	148250	9.2%
o	137621	8.5%
r	124363	7.7%
a	85412	5.3%
l	61653	3.8%
c	59538	3.7%
Other values (14)	145928	9.0%

Uppercase Letter

Value	Count	Frequency (%)
P	111449	35.7%
C	53208	17.1%
S	35849	11.5%
A	35724	11.5%
F	31185	10.0%
L	10968	3.5%
T	8316	2.7%
E	7563	2.4%
B	7363	2.4%
I	5344	1.7%
Other values (6)	4819	1.5%

Space Separator

Value	Count	Frequency (%)
	214675	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	99762	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1925514	86.0%
Common	314437	14.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	250955	13.0%
i	228514	11.9%
v	217825	11.3%
n	153667	8.0%
t	148250	7.7%
o	137621	7.1%
r	124363	6.5%
P	111449	5.8%
a	85412	4.4%
l	61653	3.2%
Other values (30)	405805	21.1%

Common

Value	Count	Frequency (%)
	214675	68.3%
-	99762	31.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2201850	98.3%
None	38101	1.7%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	250955	11.4%
i	228514	10.4%
v	217825	9.9%
	214675	9.7%
n	153667	7.0%
t	148250	6.7%
o	137621	6.3%
r	124363	5.6%
P	111449	5.1%
-	99762	4.5%
Other values (29)	514769	23.4%

None

Value	Count	Frequency (%)
ó	31344	82.3%
í	5596	14.7%
é	1161	3.0%

Tipo de Incidencia
Categorical

HIGH CORRELATION

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	115176
Mtto General	1154
Climatización	852
Eléctrica	795
Fontanería	546
Other values (16)	945

Length

Max length	15
Median length	1
Mean length	1.360866508
Min length	1

Characters and Unicode

Total characters	162580
Distinct characters	37
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	115176	96.4%
Mtto General	1154	1.0%
Climatización	852	0.7%
Eléctrica	795	0.7%
Fontanería	546	0.5%
Ventilación	284	0.2%
Calefacción	164	0.1%
Cerrajería	159	0.1%
Agua Caliente	58	< 0.1%
Frío Industrial	53	< 0.1%
Other values (11)	227	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mtto	1154	20.7%
general	1154	20.7%
climatización	852	15.3%
eléctrica	795	14.2%
fontanería	546	9.8%
ventilación	284	5.1%
calefacción	164	2.9%
cerrajería	159	2.8%
agua	58	1.0%
caliente	58	1.0%
Other values (14)	359	6.4%

Most occurring characters

Value	Count	Frequency (%)
	116467	71.6%
a	6045	3.7%
t	4982	3.1%
i	4491	2.8%
n	4054	2.5%
e	3845	2.4%
l	3430	2.1%
r	3203	2.0%
c	3134	1.9%
o	1842	1.1%
Other values (27)	11087	6.8%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	116467	71.6%
Lowercase Letter	40480	24.9%
Uppercase Letter	5633	3.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	6045	14.9%
t	4982	12.3%
i	4491	11.1%
n	4054	10.0%
e	3845	9.5%
l	3430	8.5%
r	3203	7.9%
c	3134	7.7%
o	1842	4.6%
ó	1300	3.2%
Other values (13)	4154	10.3%

Uppercase Letter

Value	Count	Frequency (%)
C	1286	22.8%
M	1176	20.9%
G	1154	20.5%
E	818	14.5%
F	619	11.0%
V	284	5.0%
A	99	1.8%
I	70	1.2%
P	57	1.0%
O	26	0.5%
Other values (3)	44	0.8%

Space Separator

Value	Count	Frequency (%)
	116467	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	116467	71.6%
Latin	46113	28.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	6045	13.1%
t	4982	10.8%
i	4491	9.7%
n	4054	8.8%
e	3845	8.3%
l	3430	7.4%
r	3203	6.9%
c	3134	6.8%
o	1842	4.0%
ó	1300	2.8%
Other values (26)	9787	21.2%

Common

Value	Count	Frequency (%)
	116467	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	159706	98.2%
None	2874	1.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	116467	72.9%
a	6045	3.8%
t	4982	3.1%
i	4491	2.8%
n	4054	2.5%
e	3845	2.4%
l	3430	2.1%
r	3203	2.0%
c	3134	2.0%
o	1842	1.2%
Other values (24)	8213	5.1%

None

Value	Count	Frequency (%)
ó	1300	45.2%
é	795	27.7%
í	779	27.1%

Prioridad
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

Baja	69723
Media	41258
	6660
Urgente	1712
Alta	115

Length

Max length	7
Median length	4
Mean length	4.221096863
Min length	1

Characters and Unicode

Total characters	504286
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Baja
2nd row	Baja
3rd row	Baja
4th row	Baja
5th row	Media

Common Values

Value	Count	Frequency (%)
Baja	69723	58.4%
Media	41258	34.5%
	6660	5.6%
Urgente	1712	1.4%
Alta	115	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
baja	69723	61.8%
media	41258	36.6%
urgente	1712	1.5%
alta	115	0.1%

Most occurring characters

Value	Count	Frequency (%)
a	180819	35.9%
B	69723	13.8%
j	69723	13.8%
e	44682	8.9%
M	41258	8.2%
d	41258	8.2%
i	41258	8.2%
	6660	1.3%
t	1827	0.4%
U	1712	0.3%
Other values (5)	5366	1.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	384818	76.3%
Uppercase Letter	112808	22.4%
Space Separator	6660	1.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	180819	47.0%
j	69723	18.1%
e	44682	11.6%
d	41258	10.7%
i	41258	10.7%
t	1827	0.5%
r	1712	0.4%
g	1712	0.4%
n	1712	0.4%
l	115	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
B	69723	61.8%
M	41258	36.6%
U	1712	1.5%
A	115	0.1%

Space Separator

Value	Count	Frequency (%)
	6660	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	497626	98.7%
Common	6660	1.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	180819	36.3%
B	69723	14.0%
j	69723	14.0%
e	44682	9.0%
M	41258	8.3%
d	41258	8.3%
i	41258	8.3%
t	1827	0.4%
U	1712	0.3%
r	1712	0.3%
Other values (4)	3654	0.7%

Common

Value	Count	Frequency (%)
	6660	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	504286	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	180819	35.9%
B	69723	13.8%
j	69723	13.8%
e	44682	8.9%
M	41258	8.2%
d	41258	8.2%
i	41258	8.2%
	6660	1.3%
t	1827	0.4%
U	1712	0.3%
Other values (5)	5366	1.1%

Coste MOI
Categorical

HIGH CORRELATION

Distinct	39
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

0.00 €	119061
71.26 €	133
15.09 €	55
17.24 €	29
14.50 €	24
Other values (34)	166

Length

Max length	9
Median length	7
Mean length	7.003004989
Min length	7

Characters and Unicode

Total characters	836635
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	0.00 €
2nd row	0.00 €
3rd row	0.00 €
4th row	0.00 €
5th row	0.00 €

Common Values

Value	Count	Frequency (%)
0.00 €	119061	99.7%
71.26 €	133	0.1%
15.09 €	55	< 0.1%
17.24 €	29	< 0.1%
14.50 €	24	< 0.1%
18.10 €	21	< 0.1%
29.00 €	15	< 0.1%
0.08 €	12	< 0.1%
0.10 €	10	< 0.1%
8.50 €	10	< 0.1%
Other values (29)	98	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
€	119468	50.0%
0.00	119061	49.8%
71.26	133	0.1%
15.09	55	< 0.1%
17.24	29	< 0.1%
14.50	24	< 0.1%
18.10	21	< 0.1%
29.00	15	< 0.1%
0.08	12	< 0.1%
8.50	10	< 0.1%
Other values (30)	108	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	357482	42.7%
	238936	28.6%
.	119468	14.3%
€	119468	14.3%
1	336	< 0.1%
7	207	< 0.1%
2	195	< 0.1%
6	165	< 0.1%
5	129	< 0.1%
4	74	< 0.1%
Other values (3)	175	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	358763	42.9%
Space Separator	238936	28.6%
Other Punctuation	119468	14.3%
Currency Symbol	119468	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	357482	99.6%
1	336	0.1%
7	207	0.1%
2	195	0.1%
6	165	< 0.1%
5	129	< 0.1%
4	74	< 0.1%
9	71	< 0.1%
8	66	< 0.1%
3	38	< 0.1%

Space Separator

Value	Count	Frequency (%)
	238936	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	119468	100.0%

Currency Symbol

Value	Count	Frequency (%)
€	119468	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	836635	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	357482	42.7%
	238936	28.6%
.	119468	14.3%
€	119468	14.3%
1	336	< 0.1%
7	207	< 0.1%
2	195	< 0.1%
6	165	< 0.1%
5	129	< 0.1%
4	74	< 0.1%
Other values (3)	175	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	717167	85.7%
Currency Symbols	119468	14.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	357482	49.8%
	238936	33.3%
.	119468	16.7%
1	336	< 0.1%
7	207	< 0.1%
2	195	< 0.1%
6	165	< 0.1%
5	129	< 0.1%
4	74	< 0.1%
9	71	< 0.1%
Other values (2)	104	< 0.1%

Currency Symbols

Value	Count	Frequency (%)
€	119468	100.0%

Coste MOE
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

0.00 €	119468

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	836276
Distinct characters	4
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.00 €
2nd row	0.00 €
3rd row	0.00 €
4th row	0.00 €
5th row	0.00 €

Common Values

Value	Count	Frequency (%)
0.00 €	119468	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0.00	119468	50.0%
€	119468	50.0%

Most occurring characters

Value	Count	Frequency (%)
0	358404	42.9%
	238936	28.6%
.	119468	14.3%
€	119468	14.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	358404	42.9%
Space Separator	238936	28.6%
Other Punctuation	119468	14.3%
Currency Symbol	119468	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	358404	100.0%

Space Separator

Value	Count	Frequency (%)
	238936	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	119468	100.0%

Currency Symbol

Value	Count	Frequency (%)
€	119468	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	836276	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	358404	42.9%
	238936	28.6%
.	119468	14.3%
€	119468	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	716808	85.7%
Currency Symbols	119468	14.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	358404	50.0%
	238936	33.3%
.	119468	16.7%

Currency Symbols

Value	Count	Frequency (%)
€	119468	100.0%

Coste Material
Categorical

HIGH CARDINALITY

Distinct	192
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

0.00 €	119275
39.00 €	2
35.00 €	2
153.76 €	1
52.00 €	1
Other values (187)	187

Length

Max length	10
Median length	7
Mean length	7.002410687
Min length	7

Characters and Unicode

Total characters	836564
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	189 ?
Unique (%)	0.2%

Sample

1st row	0.00 €
2nd row	0.00 €
3rd row	0.00 €
4th row	0.00 €
5th row	0.00 €

Common Values

Value	Count	Frequency (%)
0.00 €	119275	99.8%
39.00 €	2	< 0.1%
35.00 €	2	< 0.1%
153.76 €	1	< 0.1%
52.00 €	1	< 0.1%
682.50 €	1	< 0.1%
39.59 €	1	< 0.1%
1.80 €	1	< 0.1%
150.36 €	1	< 0.1%
16.94 €	1	< 0.1%
Other values (182)	182	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
€	119468	50.0%
0.00	119275	49.9%
39.00	2	< 0.1%
35.00	2	< 0.1%
59.82	1	< 0.1%
61.98	1	< 0.1%
16.79	1	< 0.1%
77.00	1	< 0.1%
43.60	1	< 0.1%
17.85	1	< 0.1%
Other values (183)	183	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	357960	42.8%
	238936	28.6%
.	119468	14.3%
€	119468	14.3%
1	116	< 0.1%
2	94	< 0.1%
5	86	< 0.1%
4	81	< 0.1%
7	75	< 0.1%
3	74	< 0.1%
Other values (3)	206	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	358692	42.9%
Space Separator	238936	28.6%
Other Punctuation	119468	14.3%
Currency Symbol	119468	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	357960	99.8%
1	116	< 0.1%
2	94	< 0.1%
5	86	< 0.1%
4	81	< 0.1%
7	75	< 0.1%
3	74	< 0.1%
6	74	< 0.1%
9	67	< 0.1%
8	65	< 0.1%

Space Separator

Value	Count	Frequency (%)
	238936	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	119468	100.0%

Currency Symbol

Value	Count	Frequency (%)
€	119468	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	836564	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	357960	42.8%
	238936	28.6%
.	119468	14.3%
€	119468	14.3%
1	116	< 0.1%
2	94	< 0.1%
5	86	< 0.1%
4	81	< 0.1%
7	75	< 0.1%
3	74	< 0.1%
Other values (3)	206	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	717096	85.7%
Currency Symbols	119468	14.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	357960	49.9%
	238936	33.3%
.	119468	16.7%
1	116	< 0.1%
2	94	< 0.1%
5	86	< 0.1%
4	81	< 0.1%
7	75	< 0.1%
3	74	< 0.1%
6	74	< 0.1%
Other values (2)	132	< 0.1%

Currency Symbols

Value	Count	Frequency (%)
€	119468	100.0%

Tipo de Componente
Categorical

HIGH CARDINALITY

Distinct	139
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

CALACS - Calefacción y ACS - Acumulador ACS	13342
CLI - Climatización - Fancoil	12415
CALACS - Calefacción y ACS - Bomba	11699
ELEC - Electricidad - BT - Cuadro Electrico	8557
MTOGN - Mantenimiento General - Edificios	6422
Other values (134)	67033

Length

Max length	75
Median length	64
Mean length	37.39443198
Min length	3

Characters and Unicode

Total characters	4467438
Distinct characters	61
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	ELEC - Electricidad - BT - Cuadro Electrico
2nd row	ELEC - Electricidad - BT - Cuadro Electrico
3rd row	INTS - Int Solar - Vaso Expansión
4th row	ELEC - Electricidad - BT - Cuadro Electrico
5th row	CALACS - Calefacción y ACS - Caldera Gas 70<P<1000 kW

Common Values

Value	Count	Frequency (%)
CALACS - Calefacción y ACS - Acumulador ACS	13342	11.2%
CLI - Climatización - Fancoil	12415	10.4%
CALACS - Calefacción y ACS - Bomba	11699	9.8%
ELEC - Electricidad - BT - Cuadro Electrico	8557	7.2%
MTOGN - Mantenimiento General - Edificios	6422	5.4%
CLI - Climatización - Bomba	5375	4.5%
MTOGN - Mantenimiento General - Visita	5068	4.2%
CLI - Climatización - UTA - UTA sin Humectación	4735	4.0%
PCI - Extintores	4315	3.6%
CLI - Climatización - Unidad Interior	4181	3.5%
Other values (129)	43359	36.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	265170	32.1%
acs	47749	5.8%
cli	34595	4.2%
climatización	34595	4.2%
y	34265	4.2%
calacs	34093	4.1%
calefacción	34093	4.1%
bomba	23420	2.8%
acumulador	13656	1.7%
fancoil	12415	1.5%
Other values (175)	291496	35.3%

Most occurring characters

Value	Count	Frequency (%)
	706081	15.8%
a	334798	7.5%
i	317446	7.1%
-	263212	5.9%
C	262060	5.9%
c	213004	4.8%
n	196761	4.4%
o	165560	3.7%
A	162518	3.6%
e	156237	3.5%
Other values (51)	1689761	37.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2414812	54.1%
Uppercase Letter	1037711	23.2%
Space Separator	706081	15.8%
Dash Punctuation	263212	5.9%
Decimal Number	29416	0.7%
Math Symbol	11694	0.3%
Open Punctuation	2253	0.1%
Close Punctuation	2253	0.1%
Other Punctuation	6	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	334798	13.9%
i	317446	13.1%
c	213004	8.8%
n	196761	8.1%
o	165560	6.9%
e	156237	6.5%
r	149870	6.2%
l	145967	6.0%
t	130910	5.4%
m	101112	4.2%
Other values (19)	503147	20.8%

Uppercase Letter

Value	Count	Frequency (%)
C	262060	25.3%
A	162518	15.7%
S	95801	9.2%
L	79316	7.6%
E	72944	7.0%
I	70904	6.8%
G	51386	5.0%
F	39757	3.8%
T	39673	3.8%
B	34049	3.3%
Other values (11)	129303	12.5%

Decimal Number

Value	Count	Frequency (%)
0	19616	66.7%
1	4908	16.7%
7	4892	16.6%

Math Symbol

Value	Count	Frequency (%)
<	9760	83.5%
+	1894	16.2%
>	40	0.3%

Space Separator

Value	Count	Frequency (%)
	706081	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	263212	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2253	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2253	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3452523	77.3%
Common	1014915	22.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	334798	9.7%
i	317446	9.2%
C	262060	7.6%
c	213004	6.2%
n	196761	5.7%
o	165560	4.8%
A	162518	4.7%
e	156237	4.5%
r	149870	4.3%
l	145967	4.2%
Other values (40)	1348302	39.1%

Common

Value	Count	Frequency (%)
	706081	69.6%
-	263212	25.9%
0	19616	1.9%
<	9760	1.0%
1	4908	0.5%
7	4892	0.5%
(	2253	0.2%
)	2253	0.2%
+	1894	0.2%
>	40	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4370057	97.8%
None	97381	2.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	706081	16.2%
a	334798	7.7%
i	317446	7.3%
-	263212	6.0%
C	262060	6.0%
c	213004	4.9%
n	196761	4.5%
o	165560	3.8%
A	162518	3.7%
e	156237	3.6%
Other values (47)	1592380	36.4%

None

Value	Count	Frequency (%)
ó	81468	83.7%
í	7430	7.6%
é	6678	6.9%
á	1805	1.9%

Matrícula
Categorical

HIGH CORRELATION

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	119206
NUMERO 2	18
NUMERO 3	15
GCGAS70-001	13
BMETERS	12
Other values (25)	204

Length

Max length	11
Median length	1
Mean length	1.01647303
Min length	1

Characters and Unicode

Total characters	121436
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	119206	99.8%
NUMERO 2	18	< 0.1%
NUMERO 3	15	< 0.1%
GCGAS70-001	13	< 0.1%
BMETERS	12	< 0.1%
BOM00-003	10	< 0.1%
GP000-001	10	< 0.1%
ACU00-002	10	< 0.1%
ACU00-003	10	< 0.1%
BOM00-002	10	< 0.1%
Other values (20)	154	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
numero	33	11.0%
2	18	6.0%
3	15	5.0%
gcgas70-001	13	4.3%
bmeters	12	4.0%
acu00-001	10	3.3%
frio	10	3.3%
bom00-004	10	3.3%
bom00-005	10	3.3%
bom00-001	10	3.3%
Other values (21)	159	53.0%

Most occurring characters

Value	Count	Frequency (%)
	119244	98.2%
0	664	0.5%
-	166	0.1%
O	132	0.1%
M	111	0.1%
A	102	0.1%
E	100	0.1%
C	91	0.1%
R	87	0.1%
1	86	0.1%
Other values (19)	653	0.5%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	119244	98.2%
Uppercase Letter	1138	0.9%
Decimal Number	888	0.7%
Dash Punctuation	166	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	132	11.6%
M	111	9.8%
A	102	9.0%
E	100	8.8%
C	91	8.0%
R	87	7.6%
U	84	7.4%
B	67	5.9%
S	55	4.8%
I	49	4.3%
Other values (10)	260	22.8%

Decimal Number

Value	Count	Frequency (%)
0	664	74.8%
1	86	9.7%
2	49	5.5%
3	47	5.3%
4	19	2.1%
7	13	1.5%
5	10	1.1%

Space Separator

Value	Count	Frequency (%)
	119244	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	166	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	120298	99.1%
Latin	1138	0.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	132	11.6%
M	111	9.8%
A	102	9.0%
E	100	8.8%
C	91	8.0%
R	87	7.6%
U	84	7.4%
B	67	5.9%
S	55	4.8%
I	49	4.3%
Other values (10)	260	22.8%

Common

Value	Count	Frequency (%)
	119244	99.1%
0	664	0.6%
-	166	0.1%
1	86	0.1%
2	49	< 0.1%
3	47	< 0.1%
4	19	< 0.1%
7	13	< 0.1%
5	10	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	121436	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	119244	98.2%
0	664	0.5%
-	166	0.1%
O	132	0.1%
M	111	0.1%
A	102	0.1%
E	100	0.1%
C	91	0.1%
R	87	0.1%
1	86	0.1%
Other values (19)	653	0.5%

Núm. Serie
Categorical

HIGH CARDINALITY

Distinct	1463
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	106181
18 T 1217 90436	612
19434	298
4607	297
2777	297
Other values (1458)	11783

Length

Max length	29
Median length	1
Mean length	1.765845247
Min length	1

Characters and Unicode

Total characters	210962
Distinct characters	50
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	144 ?
Unique (%)	0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row	1015809208860

Common Values

Value	Count	Frequency (%)
	106181	88.9%
18 T 1217 90436	612	0.5%
19434	298	0.2%
4607	297	0.2%
2777	297	0.2%
3434	297	0.2%
19435	297	0.2%
4527	297	0.2%
19336	297	0.2%
2776	297	0.2%
Other values (1453)	10298	8.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
18	612	3.8%
t	612	3.8%
1217	612	3.8%
90436	612	3.8%
19434	298	1.9%
4607	297	1.9%
2777	297	1.9%
3434	297	1.9%
19435	297	1.9%
4527	297	1.9%
Other values (1498)	11765	73.5%

Most occurring characters

Value	Count	Frequency (%)
	108898	51.6%
0	17592	8.3%
1	13879	6.6%
2	9568	4.5%
3	9461	4.5%
4	8520	4.0%
7	8407	4.0%
6	6559	3.1%
5	6097	2.9%
9	5874	2.8%
Other values (40)	16107	7.6%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	108898	51.6%
Decimal Number	91033	43.2%
Uppercase Letter	8360	4.0%
Dash Punctuation	1490	0.7%
Other Punctuation	968	0.5%
Other Letter	113	0.1%
Lowercase Letter	80	< 0.1%
Open Punctuation	10	< 0.1%
Close Punctuation	10	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	1051	12.6%
L	964	11.5%
E	754	9.0%
A	612	7.3%
C	538	6.4%
M	532	6.4%
P	417	5.0%
B	330	3.9%
W	316	3.8%
F	315	3.8%
Other values (16)	2531	30.3%

Decimal Number

Value	Count	Frequency (%)
0	17592	19.3%
1	13879	15.2%
2	9568	10.5%
3	9461	10.4%
4	8520	9.4%
7	8407	9.2%
6	6559	7.2%
5	6097	6.7%
9	5874	6.5%
8	5076	5.6%

Lowercase Letter

Value	Count	Frequency (%)
w	37	46.2%
b	13	16.2%
l	13	16.2%
e	13	16.2%
j	2	2.5%
o	2	2.5%

Other Punctuation

Value	Count	Frequency (%)
/	780	80.6%
.	122	12.6%
:	66	6.8%

Space Separator

Value	Count	Frequency (%)
	108898	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1490	100.0%

Other Letter

Value	Count	Frequency (%)
º	113	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	10	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	10	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	202409	95.9%
Latin	8553	4.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	1051	12.3%
L	964	11.3%
E	754	8.8%
A	612	7.2%
C	538	6.3%
M	532	6.2%
P	417	4.9%
B	330	3.9%
W	316	3.7%
F	315	3.7%
Other values (23)	2724	31.8%

Common

Value	Count	Frequency (%)
	108898	53.8%
0	17592	8.7%
1	13879	6.9%
2	9568	4.7%
3	9461	4.7%
4	8520	4.2%
7	8407	4.2%
6	6559	3.2%
5	6097	3.0%
9	5874	2.9%
Other values (7)	7554	3.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	210849	99.9%
None	113	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	108898	51.6%
0	17592	8.3%
1	13879	6.6%
2	9568	4.5%
3	9461	4.5%
4	8520	4.0%
7	8407	4.0%
6	6559	3.1%
5	6097	2.9%
9	5874	2.8%
Other values (39)	15994	7.6%

None

Value	Count	Frequency (%)
º	113	100.0%

Servicio
Categorical

HIGH CORRELATION

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	31834
Climatización	28189
Calefacción y ACS	25355
Electricidad	9055
Frío	5523
Other values (16)	19512

Length

Max length	24
Median length	17
Mean length	8.94492249
Min length	1

Characters and Unicode

Total characters	1068632
Distinct characters	31
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Electricidad
2nd row	Electricidad
3rd row
4th row	Electricidad
5th row	Calefacción y ACS

Common Values

Value	Count	Frequency (%)
	31834	26.6%
Climatización	28189	23.6%
Calefacción y ACS	25355	21.2%
Electricidad	9055	7.6%
Frío	5523	4.6%
PCI	5414	4.5%
ACS	4111	3.4%
AFS	4045	3.4%
Solar	1154	1.0%
Ventilación	1001	0.8%
Other values (11)	3787	3.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
acs	29466	21.1%
climatización	28189	20.1%
calefacción	26316	18.8%
y	25355	18.1%
electricidad	9055	6.5%
frío	5523	3.9%
pci	5414	3.9%
afs	4045	2.9%
solar	1154	0.8%
ventilación	1001	0.7%
Other values (13)	4454	3.2%

Most occurring characters

Value	Count	Frequency (%)
i	135053	12.6%
a	122765	11.5%
c	103531	9.7%
C	90729	8.5%
	84172	7.9%
l	66758	6.2%
n	61840	5.8%
ó	56812	5.3%
t	39651	3.7%
e	39269	3.7%
Other values (21)	268052	25.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	791993	74.1%
Uppercase Letter	192467	18.0%
Space Separator	84172	7.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	135053	17.1%
a	122765	15.5%
c	103531	13.1%
l	66758	8.4%
n	61840	7.8%
ó	56812	7.2%
t	39651	5.0%
e	39269	5.0%
m	28923	3.7%
z	28189	3.6%
Other values (10)	109202	13.8%

Uppercase Letter

Value	Count	Frequency (%)
C	90729	47.1%
S	34680	18.0%
A	33578	17.4%
F	9661	5.0%
E	9055	4.7%
P	6080	3.2%
I	6068	3.2%
V	1001	0.5%
M	974	0.5%
G	641	0.3%

Space Separator

Value	Count	Frequency (%)
	84172	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	984460	92.1%
Common	84172	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	135053	13.7%
a	122765	12.5%
c	103531	10.5%
C	90729	9.2%
l	66758	6.8%
n	61840	6.3%
ó	56812	5.8%
t	39651	4.0%
e	39269	4.0%
S	34680	3.5%
Other values (20)	233372	23.7%

Common

Value	Count	Frequency (%)
	84172	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1006166	94.2%
None	62466	5.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	135053	13.4%
a	122765	12.2%
c	103531	10.3%
C	90729	9.0%
	84172	8.4%
l	66758	6.6%
n	61840	6.1%
t	39651	3.9%
e	39269	3.9%
S	34680	3.4%
Other values (19)	227718	22.6%

None

Value	Count	Frequency (%)
ó	56812	90.9%
í	5654	9.1%

Centro de coste
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	119468

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119468
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	119468	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
No values found.

Most occurring characters

Value	Count	Frequency (%)
	119468	100.0%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	119468	100.0%

Most frequent character per category

Space Separator

Value	Count	Frequency (%)
	119468	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119468	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	119468	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119468	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	119468	100.0%

Operario PDA
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	76
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

	35035
DANIEL LUQUE MARTÍNEZ	5186
DANIEL GUIJARRO GALINDO	4591
MIGUEL ÁNGEL FERNÁNDEZ GUIJARRO	3899
SAID ELGANDOUZ FARES	3861
Other values (71)	66896

Length

Max length	36
Median length	29
Mean length	15.72073693
Min length	1

Characters and Unicode

Total characters	1878125
Distinct characters	41
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row
2nd row
3rd row	DANIEL LUQUE MARTÍNEZ
4th row	FELIX GARCÍA
5th row	ABEL CARVAJAL CABAS

Common Values

Value	Count	Frequency (%)
	35035	29.3%
DANIEL LUQUE MARTÍNEZ	5186	4.3%
DANIEL GUIJARRO GALINDO	4591	3.8%
MIGUEL ÁNGEL FERNÁNDEZ GUIJARRO	3899	3.3%
SAID ELGANDOUZ FARES	3861	3.2%
DIEGO HERNÁNDEZ GARCÍA	3801	3.2%
DAVID POZO RODRÍGUEZ	3666	3.1%
ABEL CARVAJAL CABAS	3520	2.9%
LAUREANO VIEJO PÉREZ	3119	2.6%
ISRAEL VILLALBA DURÁN	2944	2.5%
Other values (66)	49846	41.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
javier	11317	4.2%
daniel	9777	3.7%
guijarro	8490	3.2%
garcía	7118	2.7%
martínez	6558	2.5%
juan	6242	2.3%
david	5621	2.1%
luque	5186	1.9%
galindo	4591	1.7%
hernández	4260	1.6%
Other values (172)	198269	74.1%

Most occurring characters

Value	Count	Frequency (%)
	220373	11.7%
A	219108	11.7%
E	171443	9.1%
R	158780	8.5%
O	114324	6.1%
N	113030	6.0%
L	106763	5.7%
I	105503	5.6%
D	78817	4.2%
U	63977	3.4%
Other values (31)	526007	28.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1657730	88.3%
Space Separator	220374	11.7%
Lowercase Letter	21	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	219108	13.2%
E	171443	10.3%
R	158780	9.6%
O	114324	6.9%
N	113030	6.8%
L	106763	6.4%
I	105503	6.4%
D	78817	4.8%
U	63977	3.9%
G	63502	3.8%
Other values (20)	462483	27.9%

Lowercase Letter

Value	Count	Frequency (%)
n	4	19.0%
e	4	19.0%
u	3	14.3%
a	3	14.3%
l	2	9.5%
b	2	9.5%
r	1	4.8%
i	1	4.8%
t	1	4.8%

Space Separator

Value	Count	Frequency (%)
	220373	> 99.9%
	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1657751	88.3%
Common	220374	11.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	219108	13.2%
E	171443	10.3%
R	158780	9.6%
O	114324	6.9%
N	113030	6.8%
L	106763	6.4%
I	105503	6.4%
D	78817	4.8%
U	63977	3.9%
G	63502	3.8%
Other values (29)	462504	27.9%

Common

Value	Count	Frequency (%)
	220373	> 99.9%
	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1818790	96.8%
None	59335	3.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	220373	12.1%
A	219108	12.0%
E	171443	9.4%
R	158780	8.7%
O	114324	6.3%
N	113030	6.2%
L	106763	5.9%
I	105503	5.8%
D	78817	4.3%
U	63977	3.5%
Other values (25)	466672	25.7%

None

Value	Count	Frequency (%)
Á	24222	40.8%
Í	20313	34.2%
Ó	6546	11.0%
É	5477	9.2%
Ñ	2776	4.7%
	1	< 0.1%

tiempo_parada_horas
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

00	119450
08	10
01	8

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	238936
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	00
2nd row	00
3rd row	00
4th row	00
5th row	00

Common Values

Value	Count	Frequency (%)
00	119450	> 99.9%
08	10	< 0.1%
01	8	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
00	119450	> 99.9%
08	10	< 0.1%
01	8	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	238918	> 99.9%
8	10	< 0.1%
1	8	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	238936	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	238918	> 99.9%
8	10	< 0.1%
1	8	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	238936	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	238918	> 99.9%
8	10	< 0.1%
1	8	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	238936	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	238918	> 99.9%
8	10	< 0.1%
1	8	< 0.1%

tiempo_parada_minutos
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.00303010011

Minimum	0
Maximum	45
Zeros	119453
Zeros (%)	> 99.9%
Negative	0
Negative (%)	0.0%
Memory size	933.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	45
Range	45
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3055139477
Coefficient of variation (CV)	100.8263544
Kurtosis	11725.80367
Mean	0.00303010011
Median Absolute Deviation (MAD)	0
Skewness	106.3054263
Sum	362
Variance	0.09333877224
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	119453	> 99.9%
30	10	< 0.1%
1	2	< 0.1%
10	1	< 0.1%
5	1	< 0.1%
45	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	119453	> 99.9%
1	2	< 0.1%
5	1	< 0.1%
10	1	< 0.1%
30	10	< 0.1%
45	1	< 0.1%

Value	Count	Frequency (%)
45	1	< 0.1%
30	10	< 0.1%
10	1	< 0.1%
5	1	< 0.1%
1	2	< 0.1%
0	119453	> 99.9%

tiempo_estimado_horas
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.31435196

Minimum	0
Maximum	74
Zeros	99986
Zeros (%)	83.7%
Negative	0
Negative (%)	0.0%
Memory size	933.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	9
Maximum	74
Range	74
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.900901706
Coefficient of variation (CV)	4.48959022
Kurtosis	80.73138989
Mean	1.31435196
Median Absolute Deviation (MAD)	0
Skewness	8.000319879
Sum	157023
Variance	34.82064095
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	99986	83.7%
1	6626	5.5%
2	2971	2.5%
3	1187	1.0%
9	1087	0.9%
4	1053	0.9%
11	896	0.7%
27	872	0.7%
5	808	0.7%
16	447	0.4%
Other values (17)	3535	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	99986	83.7%
1	6626	5.5%
2	2971	2.5%
3	1187	1.0%
4	1053	0.9%
5	808	0.7%
6	417	0.3%
7	180	0.2%
8	196	0.2%
9	1087	0.9%

Value	Count	Frequency (%)
74	332	0.3%
69	74	0.1%
41	142	0.1%
36	146	0.1%
35	142	0.1%
27	872	0.7%
26	106	0.1%
21	336	0.3%
20	20	< 0.1%
18	442	0.4%

tiempo_estimado_minutos
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.6055178

Minimum	0
Maximum	58
Zeros	38368
Zeros (%)	32.1%
Negative	0
Negative (%)	0.0%
Memory size	933.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	5
Q3	15
95-th percentile	40
Maximum	58
Range	58
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	13.23289405
Coefficient of variation (CV)	1.140224356
Kurtosis	1.022509285
Mean	11.6055178
Median Absolute Deviation (MAD)	5
Skewness	1.272342705
Sum	1386488
Variance	175.109485
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	38368	32.1%
15	20112	16.8%
5	15723	13.2%
10	12001	10.0%
30	11871	9.9%
25	3305	2.8%
20	3275	2.7%
45	2768	2.3%
1	2629	2.2%
2	2152	1.8%
Other values (24)	7264	6.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38368	32.1%
1	2629	2.2%
2	2152	1.8%
3	300	0.3%
4	652	0.5%
5	15723	13.2%
6	87	0.1%
7	91	0.1%
8	588	0.5%
9	154	0.1%

Value	Count	Frequency (%)
58	59	< 0.1%
55	1150	1.0%
53	118	0.1%
50	1036	0.9%
48	576	0.5%
45	2768	2.3%
40	1136	1.0%
38	49	< 0.1%
36	192	0.2%
35	719	0.6%

tiempo_mo_horas
Real number (ℝ_≥0)

ZEROS

Distinct	67
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3582465597

Minimum	0
Maximum	95
Zeros	105592
Zeros (%)	88.4%
Negative	0
Negative (%)	0.0%
Memory size	933.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	95
Range	95
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.934920138
Coefficient of variation (CV)	5.401085049
Kurtosis	484.6365878
Mean	0.3582465597
Median Absolute Deviation (MAD)	0
Skewness	17.09973655
Sum	42799
Variance	3.743915939
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	105592	88.4%
1	6204	5.2%
2	3075	2.6%
3	1594	1.3%
4	840	0.7%
5	541	0.5%
6	346	0.3%
8	295	0.2%
7	203	0.2%
9	136	0.1%
Other values (57)	642	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	105592	88.4%
1	6204	5.2%
2	3075	2.6%
3	1594	1.3%
4	840	0.7%
5	541	0.5%
6	346	0.3%
7	203	0.2%
8	295	0.2%
9	136	0.1%

Value	Count	Frequency (%)
95	1	< 0.1%
90	1	< 0.1%
89	1	< 0.1%
84	1	< 0.1%
80	2	< 0.1%
77	2	< 0.1%
76	1	< 0.1%
72	1	< 0.1%
68	1	< 0.1%
67	1	< 0.1%

tiempo_mo_minutos
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	60
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.190343858

Minimum	0
Maximum	59
Zeros	69510
Zeros (%)	58.2%
Negative	0
Negative (%)	0.0%
Memory size	933.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5
95-th percentile	30
Maximum	59
Range	59
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	10.45037187
Coefficient of variation (CV)	2.013425729
Kurtosis	5.418848199
Mean	5.190343858
Median Absolute Deviation (MAD)	0
Skewness	2.423329879
Sum	620080
Variance	109.2102721
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	69510	58.2%
1	10850	9.1%
30	5657	4.7%
5	4020	3.4%
2	3680	3.1%
15	3021	2.5%
3	2952	2.5%
6	2264	1.9%
10	1626	1.4%
4	1523	1.3%
Other values (50)	14365	12.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	69510	58.2%
1	10850	9.1%
2	3680	3.1%
3	2952	2.5%
4	1523	1.3%
5	4020	3.4%
6	2264	1.9%
7	915	0.8%
8	1273	1.1%
9	1504	1.3%

Value	Count	Frequency (%)
59	32	< 0.1%
58	26	< 0.1%
57	30	< 0.1%
56	31	< 0.1%
55	64	0.1%
54	79	0.1%
53	56	< 0.1%
52	82	0.1%
51	45	< 0.1%
50	189	0.2%

Datetime_aviso
Date

MISSING

Distinct	885
Distinct (%)	99.4%
Missing	118578
Missing (%)	99.3%
Memory size	933.5 KiB

Minimum	2021-01-09 11:52:00
Maximum	2022-12-08 12:05:00

Histogram

Histogram with fixed size bins (bins=50)

Datetime_solicitud
Date

Distinct	8839
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Memory size	933.5 KiB

Minimum	2020-01-09 00:00:00
Maximum	2022-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Datetime_inicio
Date

MISSING

Distinct	6288
Distinct (%)	5.5%
Missing	4188
Missing (%)	3.5%
Memory size	933.5 KiB

Minimum	2020-01-09 00:00:00
Maximum	2022-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Datetime_fin
Date

MISSING

Distinct	10569
Distinct (%)	19.4%
Missing	65019
Missing (%)	54.4%
Memory size	933.5 KiB

Minimum	2020-08-07 00:00:00
Maximum	2022-12-08 18:00:00

Histogram

Histogram with fixed size bins (bins=50)

Datetime_realización
Date

MISSING

Distinct	24884
Distinct (%)	34.0%
Missing	46278
Missing (%)	38.7%
Memory size	933.5 KiB

Minimum	2021-01-12 13:51:00
Maximum	2022-12-08 18:27:00

Histogram

Histogram with fixed size bins (bins=50)

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	O.T.	Núm. Aviso	Tipo	Estado	Descripción	DNI	Desc. Equipo	Fecha Prev. Realiz.	Centro de trabajo	Árbol departamental	Tipo Intervención	Prioridad	Tipo de Componente	Núm. Serie	Servicio	Operario PDA	tiempo_estimado_horas	tiempo_estimado_minutos	tiempo_mo_minutos	Datetime_aviso	Datetime_solicitud	Datetime_inicio	Datetime_fin	Datetime_realización
0	105738	NaN	Preventivo	Realizado	Cuadro Eléctrico - Gama Mensual	EDF-V34-CE000-004	CUADRO ELÉCTRICO - S2 - EXTRACCIÓN 1	2020-01-11	REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34	EDIFICIO - VELAZQUEZ 34	Preventivo - Electricidad - BT	Baja	ELEC - Electricidad - BT - Cuadro Electrico		Electricidad		00	10	00	NaT	2020-01-11	2020-01-11 00:00:00	NaT	2022-01-31 12:53:00
1	105738	NaN	Preventivo	Realizado	Cuadro Eléctrico - Gama Mensual	EDF-V34-CE000-006	CUADRO ELÉCTRICO - S1 - GARAJE 1	2020-01-11	REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34	EDIFICIO - VELAZQUEZ 34	Preventivo - Electricidad - BT	Baja	ELEC - Electricidad - BT - Cuadro Electrico		Electricidad		00	10	00	NaT	2020-01-11	2020-01-11 00:00:00	NaT	2022-01-31 12:53:00
2	124981	NaN	Preventivo	Realizado	Vaso Expansión - Gama Mensual	SAT-R03-VPPE-VEXP0-004	VASO DE EXPANSIÓN - SOLAR - VE04 (400L)	2021-01-03	VP HOTELES - SAT 2 - VP PLAZA DE ESPAÑA DESIGN	SAT - RUTA 03 - VP PLAZA DE ESPAÑA DESIGN	Preventivo - AFS	Baja	INTS - Int Solar - Vaso Expansión			DANIEL LUQUE MARTÍNEZ	00	08	00	NaT	2021-01-03	2021-01-03 00:00:00	2022-04-25 00:01:00	2022-04-25 08:38:00
3	133466	NaN	Preventivo	Realizado	Cuadro Eléctrico - Gama Mensual	EDF-OS11-P05-TERZ-CE000-023	CUADRO ELÉCTRICO - CE-ASC.A1	2021-01-04	TORRE RIOJA MADRID S.A. - SAT 1 - OSIRIS 11	EDIFICIO - OSIRIS 11 (ROCHE) - PLANTA QUINTA - TERRAZA	Preventivo - Electricidad - BT	Baja	ELEC - Electricidad - BT - Cuadro Electrico		Electricidad	FELIX GARCÍA	09	20	09	NaT	2021-01-04	2021-09-04 09:00:00	2021-09-04 17:30:00	2022-01-25 08:24:00
4	139777	NaN	Preventivo	Realizado	Caldera Gas - Gama Trimestral	SAT-R09-SANM-SANMAS-GCA70-004	CALDERA ACS - 65 kW	2021-01-05	SANITAS MAYORES, S.L. - SAT 2 - SANITAS ARTURO SORIA	SAT - RUTA 09 - SANITAS MAYORES, S.L. - SANITAS ARTURO SORIA	Preventivo - Calefacción y ACS	Media	CALACS - Calefacción y ACS - Caldera Gas 70<P<1000 kW	1015809208860	Calefacción y ACS	ABEL CARVAJAL CABAS	00	10	02	NaT	2021-01-05	2021-01-05 00:00:00	2021-03-05 00:02:00	2022-11-02 11:13:00
5	148670	NaN	Preventivo	Realizado	Cuadro Eléctrico - Gama Mensual	EDF-V34-CE000-007	CUADRO ELÉCTRICO - S1 - GARAJE 2	2021-01-07	REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34	EDIFICIO - VELAZQUEZ 34	Preventivo - Electricidad - BT	Baja	ELEC - Electricidad - BT - Cuadro Electrico		Electricidad		00	10	00	NaT	2021-01-07	2021-01-07 00:00:00	NaT	2022-01-31 12:53:00
6	153587	NaN	Preventivo	Realizado	Cuadro Eléctrico - Gama Mensual	EDF-OS11-S04-PCIB-CE000-054	CUADRO ELÉCTRICO - CP-INC2	2021-01-08	TORRE RIOJA MADRID S.A. - SAT 1 - OSIRIS 11	EDIFICIO - OSIRIS 11 (ROCHE) - SOTANO 4 - SALA PCI B (PLAZA 08) (HIDRANTES)	Preventivo - Electricidad - BT	Baja	ELEC - Electricidad - BT - Cuadro Electrico		Electricidad	FELIX GARCÍA	09	20	09	NaT	2021-01-08	2021-09-09 09:00:00	2021-09-09 17:30:00	2022-01-25 08:30:00
7	153587	NaN	Preventivo	Realizado	Cuadro Eléctrico - Gama Mensual	EDF-OS11-P06-INT-CE000-029	CUADRO ELÉCTRICO - CE-INS	2021-01-08	TORRE RIOJA MADRID S.A. - SAT 1 - OSIRIS 11	EDIFICIO - OSIRIS 11 (ROCHE) - AZOTEA - PLANTA INSTALACIONES	Preventivo - Electricidad - BT	Baja	ELEC - Electricidad - BT - Cuadro Electrico		Electricidad	FELIX GARCÍA	09	20	09	NaT	2021-01-08	2021-09-09 09:00:00	2021-09-09 17:30:00	2022-01-25 08:30:00
8	148670	NaN	Preventivo	Realizado	Cuadro Eléctrico - Gama Mensual	EDF-V34-CE000-014	CUADRO ELÉCTRICO - P1.OF1	2021-01-07	REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34	EDIFICIO - VELAZQUEZ 34	Preventivo - Electricidad - BT	Baja	ELEC - Electricidad - BT - Cuadro Electrico		Electricidad		00	10	00	NaT	2021-01-07	2021-01-07 00:00:00	NaT	2022-01-31 12:53:00
9	148670	NaN	Preventivo	Realizado	Cuadro Eléctrico - Gama Mensual	EDF-V34-CE000-016	CUADRO ELÉCTRICO - P2.OF2	2021-01-07	REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34	EDIFICIO - VELAZQUEZ 34	Preventivo - Electricidad - BT	Baja	ELEC - Electricidad - BT - Cuadro Electrico		Electricidad		00	10	00	NaT	2021-01-07	2021-01-07 00:00:00	NaT	2022-01-31 12:53:00

Last rows

	O.T.	Núm. Aviso	Tipo	Estado	Descripción	DNI	Desc. Equipo	Generador OT	Fecha Prev. Realiz.	Descripción de los Trabajos Realizados	Observaciones	Centro de trabajo	Árbol departamental	Tipo Intervención	Tipo de Incidencia	Prioridad	Coste Material	Tipo de Componente	Servicio	Operario PDA	tiempo_mo_horas	tiempo_mo_minutos	Datetime_aviso	Datetime_solicitud	Datetime_inicio	Datetime_fin	Datetime_realización
119458	214161	NaN	Correctivo	Abierto	Aviso en QBE, problemas frigorifico	EDF-MM-C31-EDF-MTOGN	MANTENIMENTO GENERAL	MARÍA MENDOZA ARÉVALO	2022-07-06			MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - EDIFICIO PIRAMIDE (CASTELLANA 31)	EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 31 (EDF PIRÁMIDE) - EDIFICIO		Mtto General		0.00 €	MTOGN - Mantenimiento General - Edificios			00	00	NaT	2022-07-06 13:19:00	NaT	NaT	NaT
119459	214150	NaN	Correctivo	Realizado	SUST. VENTILADOR CUARTO FRÍO COCINA	SAT-R09-HVSH.C-MTOGN	MANTENIMIENTO GENERAL	JUAN VAZQUEZ	2022-07-06	Se realiza sustitución del motor de uno de los dos ventiladores del cuarto frío.		VINCCI HOTELES, S.A. - SAT 2 - VINCCI SOHO COCINAS	SAT - RUTA 09 - VINCCI SOHO COCINAS	Aviso - TF			104.19 €	MTOGN - Mantenimiento General - Visita		ABEL CARVAJAL CABAS	04	00	NaT	2022-07-06 10:35:00	2022-07-06 00:00:00	2022-07-06 04:00:00	2022-07-06 10:20:00
119460	214151	NaN	Correctivo	Realizado	Oficina	SAT-R09-SIM-MTOGN	MANTENIMIENTO GENERAL	RAMÓN DE CASTRO GAVILÁN	2000-01-01			SIMALGA, S.L. - SIN SAT - SIMALGA OFICINA	SAT - RUTA 09 - SIMALGA, S.L.				0.00 €	MTOGN - Mantenimiento General - Visita			07	45	NaT	2022-07-06 10:36:00	2022-03-06 08:00:00	2022-06-24 00:45:00	2022-06-30 13:14:00
119461	214153	NaN	Correctivo	Realizado	Fuga del retorno de ACS: están mojando las bombas de retorno de solar. Comprobar fuga y corroborar que el solar funciona.	SAT-R02-CPPN-MTOGN	MANTENIMIENTO GENERAL	JUAN VAZQUEZ	2022-07-06	Se acomete reparación y saneamiento de un tramo de tubería de cobre de 35 mm, con fuga de agua en circuito general de retorno de agua caliente sanitaria. Se ajustan presiones de los circuitos y se comprueba el correcto funcionamiento.	David: 622837069	CP PABLO NERUDA 78 - SAT 1 - CP PABLO NERUDA 78	SAT - RUTA 02 - CP PABLO NERUDA 78	Aviso - TF			163.50 €	MTOGN - Mantenimiento General - Visita		MIGUEL ÁNGEL FERNÁNDEZ GUIJARRO	08	00	NaT	2022-07-06 10:53:00	2022-07-06 12:00:00	2022-07-06 14:00:00	2022-08-06 11:46:00
119462	214156	NaN	Correctivo	Realizado	LECTURA DIARIA DE CO2	EDF-MM-C33-ED-AAMB0-001	CALIDAD INTERIOR DEL AIRE	ARTURO MORENO PEÑA	2022-07-06	LECTURA DIARIA DE CO2		MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - MUTUA - CASTELLANA 33	EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 33 - EDIFICIO	Solicitudes FM	Ventilación	Media	0.00 €	GEN - Genérico - Estudio Calidad del Aire (CAI)			01	45	NaT	2022-07-06 12:20:00	NaT	NaT	2022-07-06 12:22:00
119463	214157	NaN	Correctivo	Realizado	54201 Sum. y sust. de válvula de flotador para llenado de torre de refrigeración.	SAT-R01-CPA102-MTOGN	MANTENIMIENTO GENERAL	JUAN VAZQUEZ	2022-07-06	Se sustituye boya torre de refrigeración centro. Se comprueba su correcto funcionamiento		CP ALMANSA, 102 - SAT 1 - ALMANSA 102	SAT - RUTA 01 - CP ALMANSA, 102	Presupuesto			0.00 €	MTOGN - Mantenimiento General - Visita		ISRAEL VILLALBA DURÁN	01	00	NaT	2022-07-06 12:29:00	2022-10-06 11:00:00	2022-10-06 12:00:00	2022-10-06 13:08:00
119464	214158	NaN	Correctivo	Realizado	LECTURA DIARIA DE CONTADORES	EDF-MM-C33-JD-CONT-009	CONTADORES DE AGUA GENERAL	ARTURO MORENO PEÑA	2022-07-06	LECTURA DIARIA DE CONTADORES		MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - MUTUA - CASTELLANA 33	EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 33 - JARDÍN	Solicitudes FM	Fontanería	Media	0.00 €	CONT - Contador - Agua	Medición Consumos		01	00	NaT	2022-07-06 12:37:00	NaT	NaT	2022-07-06 12:37:00
119465	214160	NaN	Correctivo	Realizado	No llega tensión al ascensor del centro.	SAT-R05-AECC-MTOGN-001	MANTENIMIENTO GENERAL	AVELINO GARCIA	2022-07-06	Se dan indicaciones de manera telefónica, pero es necesario desplazarse al centro ya que nos comunican que el personal de ascensores no ve nada raro en cuadro general de planta-1.\r\nUna vez en el centro observamos que el automático general de montacargas + relé de rearme está caído.\r\nSe rearma y se comprueba correcto funcionamiento.\r\nLlamarán a personal de ascensores para realizar las pruebas pertinentes.		ASOCIACIÓN ESPAÑOLA CONTRA EL CANCER (AECC) - SAT 1 - ASOCIACIÓN ESPAÑOLA CONTRA EL CANCER (AECC)	SAT - RUTA 05 - ASOCIACIÓN ESPAÑOLA CONTRA EL CANCER	Aviso - TF	Eléctrica		0.00 €	MTOGN - Mantenimiento General - Visita		JAVIER TERRÉS GÓMEZ	02	30	NaT	2022-07-06 13:01:00	2022-07-06 12:30:00	2022-07-06 14:00:00	2022-07-06 15:00:00
119466	214163	NaN	Correctivo	Realizado	Acompañamiento junto a Carrier	SAT-R09-ALHELI-MTOGN	MANTENIMIENTO GENERAL	JUAN VAZQUEZ	2022-07-06	Acompañamiento junto con técnicos de control para solucionar averías de control.\n\n- Se detecta condición de motobombas de retorno de acs, la cual se elimina, que hacía parar las bombas si los depósitos bajaban de 53°C por lo que a primera hora con gran demanda podían parar provocando que el agua caliente tardase en llegar, sobre todo en los portales más alejados.\n\n\n- Crean un nuevo gráfico para controlar individualmente las bombas de primario de acs, que estaban funcionando las dos a la vez 24h.	viernes 10/06 entre 08:00 y 08:30	CP ALHELÍ 3 EDIFICIO RESIDENCIAL ESCALONIA. - SAT 2 - CP ALHELÍ 3 EDIFICIO RESIDENCIAL ESCALONIA	SAT - RUTA 09 - CP ALHELÍ 3 EDIFICIO RESIDENCIAL ESCALONIA	Aviso - CM			0.00 €	MTOGN - Mantenimiento General - Visita	Mtto General	ARTURO DE LAS HERAS MARCIAL	03	00	NaT	2022-07-06 13:48:00	2022-10-06 08:00:00	2022-10-06 11:00:00	2022-06-13 11:33:00
119467	214164	NaN	Correctivo	Realizado	SE CAMBIA GOMA DE ENCHUFE EN TAZA CABINA DERECHA	EDF-MM-C33-P05-AS-ASEOS-005	ASEOS P05	ARTURO MORENO PEÑA	2022-07-06	SE CAMBIA GOMA DE ENCHUFE EN TAZA CABINA DERECHA		MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - MUTUA - CASTELLANA 33	EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 33 - PLANTA 5 - ASEOS	Correctivo	Fontanería	Media	0.00 €	GEN - Genérico - Aseo			01	00	NaT	2022-07-06 14:08:00	NaT	NaT	2022-07-06 14:13:00

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Control

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Other Letter

Modifier Symbol

Other Symbol

Connector Punctuation

Final Punctuation

Initial Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Lowercase Letter

Dash Punctuation

Other Punctuation

Connector Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values